Oliver Ferns via OfficeKB.com

Posts: n/a

Hi,
You can't. You will have to protect each one individually (I believe).

For X = 1 to 3
Sheets(x).protect
Next

Hth,
O

--
Message posted via http://www.officekb.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
workbook protection	John	New Users to Excel	1	January 22nd 05 12:55 PM
Seeking help for total worksheet protection	Joseph Geretz	Excel Discussion (Misc queries)	10	December 31st 04 06:48 PM
protection on excel forms	cben	Excel Worksheet Functions	1	December 14th 04 02:23 PM
How may I remove Office 2003 DRM protection from DOC & XLS files?	Locked out	Excel Discussion (Misc queries)	1	December 12th 04 05:22 PM
Cell Colors and Sheet Protection	cincode5	Excel Discussion (Misc queries)	1	December 3rd 04 10:39 PM

All times are GMT +1. The time now is 03:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us