Can you lock just a specific worksheet in a document from editing?
Can you lock just a specific worksheet in a document from editing?
See link
http://www.bettersolutions.com/excel...E028820332.htm
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
When you turn on protection, you are actually only protecting that worksheet in the workbook. If you protect the workbook itself, without protecting any sheets, users will have full access to the data in every sheet.
Without using a macro, you'd have to go to each sheet and perform the Tools -> Protection -> Protect Sheet function and set a password. Skip the sheet you want to leave unprotected, of course.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks