T
tango
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 Structure:=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
"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 Structure:=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