protect workbook and allow hide/show worksheet

[tango]

Dear All,
pls help. really no way to allow like Sheets(2).Visible = False or true
when have ActiveWorkbook.Protect structure:=True, Windows:=False
together?
by the way, what is this syntax for? :=
when we can use?

thank you so much.




Re: unable to have workbook protect
From: Harald Staff
Date Posted: 10/18/2004 2:06:00 AM

dear all, with protect statement but i got the error message
"unable to set the visible property of worksheet class"

You can't hide/show sheets in a protected workbook, so the code must
unprotect -show/hide -reprotect.

another issue is why i cannot make a reply to the forum? the site
saying that my password is invalid but why i can create new message?

This is not s forum, ithis is a usenet newsgroup that you may be accessing
from some website frontend. Connect directly with Outlook Express or a
similar newsreader. See http://www.mvps.org/dmcritchie/ie/oe6nws01.htm

HTH. Best wishes Harald

 

[Dave Peterson]

Sometimes it's easier to just record a macro when you do it manually.