protect workbook and allow hide/show worksheet
 

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

thank you so much.




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



"tango" skrev i melding
om...
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

protect workbook and allow hide/show worksheet
 

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



tango wrote:

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

thank you so much.

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

"tango" skrev i melding
om...
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