Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide, unhide column or row after protect worksheet | Excel Discussion (Misc queries) | |||
Protect or Hide all worksheets in a workbook except 1 | Excel Worksheet Functions | |||
Hide and password protect a worksheet | Excel Discussion (Misc queries) | |||
hide a column in a worksheet and password protect | Excel Discussion (Misc queries) | |||
Protect hide worksheet | Excel Worksheet Functions |