Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Proteting against a button press
Hi:
I have a spreadsheet containing buttons which activate macros. I want to protect one sheet in the workbook so that no one can write on it, and no one can activate the buttons without a password. When I protect sheet, I find that while the cells are protected the button can be activated. Can someone tell me how to set the BUTTONS so that they cant be pressed and activate the macros. Thanks a lot JOhn Baker |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Proteting against a button press
You could use the sheet activate event to disable the buttons or hide them
(check the protection status of the sheet) You could have each button's macro check the state of the sheet and jump out without doing anything if it is protected. If you need more help, specify where the buttons are from; control toolbox toolbar or forms toolbar. -- Regards, Tom Ogilvy "John Baker" wrote in message ... Hi: I have a spreadsheet containing buttons which activate macros. I want to protect one sheet in the workbook so that no one can write on it, and no one can activate the buttons without a password. When I protect sheet, I find that while the cells are protected the button can be activated. Can someone tell me how to set the BUTTONS so that they cant be pressed and activate the macros. Thanks a lot JOhn Baker |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Proteting against a button press
Tom:
They are from the control toolbox. If i were to use the macro to check the state of the sheets protection, how would I go about it? Its a viable alternative, since I only have three buttons on that sheet, and they link to everything I want to protect. Regards John Baker "Tom Ogilvy" wrote: You could use the sheet activate event to disable the buttons or hide them (check the protection status of the sheet) You could have each button's macro check the state of the sheet and jump out without doing anything if it is protected. If you need more help, specify where the buttons are from; control toolbox toolbar or forms toolbar. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Proteting against a button press
How about:
Option Explicit Private Sub CommandButton1_Click() If Me.ProtectContents _ Or Me.ProtectDrawingObjects _ Or Me.ProtectScenarios Then MsgBox "can't run on this protected worksheet" Exit Sub End If 'your code here MsgBox "hi" End Sub John Baker wrote: Tom: They are from the control toolbox. If i were to use the macro to check the state of the sheets protection, how would I go about it? Its a viable alternative, since I only have three buttons on that sheet, and they link to everything I want to protect. Regards John Baker "Tom Ogilvy" wrote: You could use the sheet activate event to disable the buttons or hide them (check the protection status of the sheet) You could have each button's macro check the state of the sheet and jump out without doing anything if it is protected. If you need more help, specify where the buttons are from; control toolbox toolbar or forms toolbar. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find&press button | New Users to Excel | |||
urgent help!find&press,please | Excel Discussion (Misc queries) | |||
Is It Possible To Have... After A Button Press A Message Pops Up ? | Excel Worksheet Functions | |||
When I Press the Enter Key Nothing happens. | Excel Discussion (Misc queries) | |||
test for key press | Excel Programming |