98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - Protecting Multiple Worksheets
excel training seminar - Protecting Multiple Worksheets
Resolved · Low Priority · Version Standard
Fri 2 Feb 2007, 14:52Delegate Paul said...
Paul has attended:
Excel Advanced course
Protecting Multiple Worksheets
Is there a fn to protect multiple worksheets at once rather than going into each one to protect them?
Tue 6 Feb 2007, 09:28Trainer Richard said...
RE: Protecting Multiple Worksheets
You have the option of locking the entire workbook. If this is something that would work for you, here are the steps:
On the File menu, click Save As.
On the Tools menu, click General Options.
Do either or both of the following:
If you want users to enter a password before they can view the workbook, type a password in the Password to open box, and then click OK.
If you want users to enter a password before they can save changes to the workbook, type a password in the Password to modify box, and then click OK.
When prompted, retype your passwords to confirm them.
Click Save.
If prompted, click Yes to replace the existing workbook.
Hope you enjoyed your Microsoft Excel training advanced course the other day. Remember your friends and colleagues can currently use this forum free of charge.
Tue 6 Feb 2007, 10:30Delegate Paul said...
RE: Protecting Multiple Worksheets
Richard,
I have worksheets within a workbook that contain data for the entire business, I only want certain teams to be able to view the data relating to them.
I have set up "custom views" for each team but unless I protect each and every worksheet then they can just "unhide" the other teams data.
I know that I can go into each and every sheet in the workbook (about 15) and protect them individually, but I thought there may be a way of doing it universally for the workbook. Protecting the workbook still allows the user access to hidden rows and columns, just not hidden worksheets.
Any ideas?
Thanks
Paul
Tue 6 Feb 2007, 11:56Trainer Richard said...
RE: Protecting Multiple Worksheets
Thanks Paul.
My thought would be that it would probably be better to do it one by one, as it is a sensitive operation.
Perhaps one of our other trainers has some ideas regarding this. Please post an answer if you have one.
Sun 18 Feb 2007, 20:48Delegate Paul said...
RE: Protecting Multiple Worksheets
Richard,
I came up with the idea of writing a macro to protect the multiple sheets. This works but unfortunately the sheets can then be unprotected without using the password I have set. Do you know how I can rectify this?
Many thanks
Paul
Wed 11 Apr 2007, 09:46Trainer Carlos said...
RE: Protecting Multiple Worksheets
Paul
This looks like it will be consultancy work, my colleague Jacob will be contacting you.
Regards
Carlos
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create own ribbon tab - Excel 2010a. In Excel click on the File tab |
