Monday, July 18, 2005

Macros disabled in this project.

Micorosft Excel installs out of the box with macro security set to high. This means none of your macros will run while it is in this mode.
To change you will need a workbook open then go to Tools | Macros | Security and select one of the options.
High - no macros will run unless theu have been signed as trusted.
Medium - you will be prompted on opening the workbook whether you want to enable macros or not (Workbooks can have Auto Open macros which run on opening the workbook). This is the safest option as you can always disable macros if you are unsure.
Low - just open it anyway. Only use this option if you regularly open files of your own or that you know are safe.
If you move to a differnt machine on your network or reinstall office then you will need to reset this.


Posted by: Jethro | 9:24 AM |