J John Nov 3, 2003 #1 Is there a way to force the user to Enable Macro when it's opened? Thanks, John
K Kevin Stecyk Nov 3, 2003 #2 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
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
G Gord Dibben Nov 3, 2003 #3 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
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
