Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unable to have workbook protect
dear all, with protect statement but i got the error message
"unable to set the visible property of worksheet class" actually i want to disallow user to add/delete/resequence the worksheet in the workbook but the visibility of the sheet is controlled by scripts. how? pls help. 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? Private Sub Workbook_Open() ActiveWorkbook.Protect Structu=True, Windows:=False Sheets(2).Visible = True Sheet2.CommandButtonDESB.Visible = False Sheet2.CommandButtonKNDP.Visible = False Sheet2.Label1.Visible = False Sheet2.Label2.Visible = False Sheets(1).Visible = False Sheets(3).Visible = False Sheets(4).Visible = False Sheet2.CommandButton1.Visible = True Sheet2.Label9.Visible = True ThisWorkbook.Saved = True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
unable to have workbook protect
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to password-protect "VeryHidden" worksheet | New Users to Excel | |||
unable to protect cells in macro sheet b/c runtime error 1004 | Excel Worksheet Functions | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
Protect Sheet but enable cell ranges giving Error 1004 Unable to set | Excel Programming | |||
Unable cut in workbook | Excel Programming |