gimli
11-03-2010, 05:25 AM
Hi all,
Just have some questions about 2007 and macros....
We just got an upgrade to 2007 and have a questions about enabling macros.
1. Is there a way to automatically enable macros or will there always be a prompt "Securtiy Warning - some active content has been disabled" prompting the user select enable content?
2. There is an option under "save as" called excel macro enabled workbook. Should I save it under this format ?? Will this be the best way?
3. Is there a setting that can be made by each user to always enable macros without getting that security warning?
Basically im looking for the best option to save my workbooks with VBA for distributution.
thanks much
Just have some questions about 2007 and macros....
We just got an upgrade to 2007 and have a questions about enabling macros.
1. Is there a way to automatically enable macros or will there always be a prompt "Securtiy Warning - some active content has been disabled" prompting the user select enable content?
2. There is an option under "save as" called excel macro enabled workbook. Should I save it under this format ?? Will this be the best way?
3. Is there a setting that can be made by each user to always enable macros without getting that security warning?
Basically im looking for the best option to save my workbooks with VBA for distributution.
thanks much