| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting macros
I have a protected sheet with buttons assigned to macros. Howver the buttons
are not protected and can be reassigned by a user using the R mouse menu. Any ideas to help would be gratefully received |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting macros
Hi,
On the tab press right click on the mouse, view code, tools, VBA properties, protection, enter your password "Alec Mclintock" wrote: I have a protected sheet with buttons assigned to macros. Howver the buttons are not protected and can be reassigned by a user using the R mouse menu. Any ideas to help would be gratefully received |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting macros
Thanks for input - have fixed with a combination of all replies
"Eduardo" wrote: Hi, On the tab press right click on the mouse, view code, tools, VBA properties, protection, enter your password "Alec Mclintock" wrote: I have a protected sheet with buttons assigned to macros. Howver the buttons are not protected and can be reassigned by a user using the R mouse menu. Any ideas to help would be gratefully received |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting macros
when you protect the sheet, ensure edit objects is not selected
"Alec Mclintock" <Alec wrote in message ... I have a protected sheet with buttons assigned to macros. Howver the buttons are not protected and can be reassigned by a user using the R mouse menu. Any ideas to help would be gratefully received |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting macros
when you protect the sheet, ensure edit objects is not selected
"Alec Mclintock" <Alec wrote in message ... I have a protected sheet with buttons assigned to macros. Howver the buttons are not protected and can be reassigned by a user using the R mouse menu. Any ideas to help would be gratefully received |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting VBA Macros | Excel Programming | |||
| Protecting My Macros | Excel Worksheet Functions | |||
| password protecting macros | Excel Programming | |||
| Protecting Macros | Excel Programming | |||
| Protecting Macros -is it possible | Excel Programming | |||
Hybrid Mode
