Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Button Security
Hi everyone,
What I would like to do is to stop somebody right clicking the Form Button and assigning another Macro to it. I have Passworded the VBA Code. Any help will be greatly appreciated. Thanks in advance. All the Best. Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Button Security
Hi Paul,
Try: '============= Private Sub Workbook_Activate() Application.CommandBars("Excel Control"). _ FindControl(ID:=859).Enabled = False End Sub '-------------- Private Sub Workbook_Deactivate() Application.CommandBars("Excel Control"). _ FindControl(ID:=859).Enabled = True End Sub '-------------- Private Sub Workbook_Open() Application.CommandBars("Excel Control"). _ FindControl(ID:=859).Enabled = False End Sub '<<============= This is workbook event code and should be pasted into the workbook's ThisWorkbook module *not* a standard module or a sheet module: Right-click the Excel icon on the worksheet (or the icon to the left of the File menu if your workbook is maximised) Select 'View Code' from the menu and paste the code. Alt-F11 to return to Excel. --- Regards, Norman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Button Security
Thanks for the reply Norman, I will certainly give it a go.
All the Best. Paul Norman Jones wrote: Hi Paul, Try: '============= Private Sub Workbook_Activate() Application.CommandBars("Excel Control"). _ FindControl(ID:=859).Enabled = False End Sub '-------------- Private Sub Workbook_Deactivate() Application.CommandBars("Excel Control"). _ FindControl(ID:=859).Enabled = True End Sub '-------------- Private Sub Workbook_Open() Application.CommandBars("Excel Control"). _ FindControl(ID:=859).Enabled = False End Sub '<<============= This is workbook event code and should be pasted into the workbook's ThisWorkbook module *not* a standard module or a sheet module: Right-click the Excel icon on the worksheet (or the icon to the left of the File menu if your workbook is maximised) Select 'View Code' from the menu and paste the code. Alt-F11 to return to Excel. --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro and button security | Excel Programming | |||
Form Security | Excel Discussion (Misc queries) | |||
Command Button vs Form Button | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
Command Button vs Form Button | Excel Programming |