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

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

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

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

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