Enable Macro

[John]

Is there a way to force the user to Enable Macro when
it's opened?

Thanks,
John

 

[Kevin Stecyk]

AFAIK, no there is no way. If there were, then Excel would be an excellent
way to spread viruses. So I am fairly confident that there is NO way to
~force~ a user to Enable Macro when it is opened. But I could be wrong.

Regards,
Kevin

 

[Gord Dibben]

John

There is no way to force users to enable macros. However, you can make your
workbook unusable if they don't and add a warning message telling them so.

For some details and code go to these Google Search results.

http://snurl.com/2tdh

To see more results try a Google search on "Force Macros".

For easy Google searching download Ron de Bruin's google search add-in from

http://www.rondebruin.nl/index.html

Best thing since sliced bread.

Gord Dibben XL2002