Posted to microsoft.public.excel.programming
|
|
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
|