Prevent user from running Macro

GeorgeB · Mar 9th, 2002, 10:16 PM

Hi all
Any way to prevent a user from running a Macro from the dialog box. I have some procedures that create pivot tables and charts for certain eyes only.
Thanks
GeorgeB

Ivan F Moala · Mar 9th, 2002, 10:56 PM

Put
Option Private Module
In the module where you don't want the
macros to be listed.....

Ivan

GeorgeB · Mar 10th, 2002, 07:31 AM

Thanks Ivan
I never cease to be amazed by your expertise.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 9th, 2002, 10:16 PM	#1
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Hi all Any way to prevent a user from running a Macro from the dialog box. I have some procedures that create pivot tables and charts for certain eyes only. Thanks GeorgeB

Mar 9th, 2002, 10:56 PM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Put Option Private Module In the module where you don't want the macros to be listed..... Ivan

Mar 10th, 2002, 07:31 AM	#3
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Thanks Ivan I never cease to be amazed by your expertise.