Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locking the macros etc
- Thread starter User4Fun
- Start date
to open a sheet when a spreadsheet opens you need to go to the VBA Code of "ThisWorkbook" (rather than the code for a single sheet)
then in there you can have
where "Sheet3" is the name of your sheet
and as for trying to lock macro's and buttons, I'm not sure about the macro's but for the buttons you can use:
where CommandButton1 is the name of your button
then in there you can have
Code:
Private Sub Workbook_Open()
Sheets("Sheet3").Select
End Suband as for trying to lock macro's and buttons, I'm not sure about the macro's but for the buttons you can use:
Code:
Me.CommandButton1.Locked = True- Status
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question