Hi,
So I want to protect a work book that contains 50 sheets. I dont want people to be able to edit the contents of each individual sheet without having a password.
I tried the following; tools---> protection----> protect workbook---> structure, but people could still edit the actual contents of each sheet
I know I could individually protect each sheet, but since I have a few of these 50+ sized workbooks to do, that would be a huge waste of my time
Anyone think of a better way (preferrably non-VBA)?
Here is a recent thread on that
http://www.excelforum.com/excel-gene...ml#post2219303
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks