Protecting macros
in [Programming]
|
From: Alec Mclintock Alec on 25 Mar 2010 06:06 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
From: Eduardo on 25 Mar 2010 08:06 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
From: Anthony on 25 Mar 2010 07:50 when you protect the sheet, ensure edit objects is not selected "Alec Mclintock" <Alec Mclintock(a)discussions.microsoft.com> wrote in message news:9D22B5E4-21A2-4477-9762-645C0A2DD504(a)microsoft.com... > 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
From: Anthony on 25 Mar 2010 08:07 when you protect the sheet, ensure edit objects is not selected "Alec Mclintock" <Alec Mclintock(a)discussions.microsoft.com> wrote in message news:9D22B5E4-21A2-4477-9762-645C0A2DD504(a)microsoft.com... > 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
From: Alec Mclintock on 25 Mar 2010 10:50 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
|
Pages: 1 Prev: UserForm Text Box to display worksheet cell text Next: Excel 2007 ADO Connection Error |