Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » Make macros work in newer versions of Excel
Make macros work in newer versions of Excel
If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.
To do this, go to Tools - Options - Security.
Select Macro Security and change the security setting to Low.
Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.
After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.
Added by Amanda on 24th November 2006
More Excel hints and tips, like:
 |
|
» Forum post: Cascading Combo boxes |
Hi,
