Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel add but no modify

Status
Not open for further replies.

techie131

MIS
Jun 23, 2005
60
CA
Is there a way to lock the excel file so people can input data but not modify that data afterwards. Such as Users can add data to blank cells but not change any cells with data already in it
 




Not with native Excel functionality.

But are you REALLY SURE that's what you want? after all, there are typos.

Can be done with VBA. Post in Forum707.

Skip,

[glasses]Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top