microsoft+excel+training - How do you automatically prtotect multiple worksheets

The UK's most regular instructor-led training courses.
Training information: microsoft+excel+training · Excel course · VBA training in London

Resolved · Low Priority · Version Standard

How do you automatically prtotect multiple worksheets

Ryan has attended:
Excel VBA course

by - delegate Ryan [1 post] (2007 Jul 18 Wed, 09:00) Reply

Is it possible to automatically protect and unprotect multiple worksheets using a macro? Is it also possible to hide and unhide multiple worksheets using a macro?

Thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2007	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 17 Fri	Southwark	4	book now	£224	£235
2003	2008 Oct 22 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 22 Wed	Bayswater	5	book now	£195	£205
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: How do you automatically prtotect multiple worksheets

by - trainer Anthony gold contributer [113 posts] (2007 Jul 18 Wed, 16:16) Reply

Hi Ryan. The simplest way to generate the code for this is to record a macro and then carry out the tasks. You can protect the current worksheet by accessing the ActiveSheet.Protect object and sheets can be similarly hidden simply by specifying which ones you want. Create macros to protect/unprotect, hide/unhide, assign them to icons on your toolbar and you're away!

Hope this helps,

Anthony

· Microsoft Excel Features and Functions for Accountants
· How to Create Better Excel Spreadsheets: Part One
· A Beginners Guide To Formulas In Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training: Not Just for Newbies Anymore