See
http://www.rondebruin.nl/password2007.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Salman" wrote in message ...
I record a macro in Excel (2007). It worked fine but when I saved, closed and
reopened the same file I cant run the same macro. Its showing following error
message:
€˜Because of your security settings, macro have been disabled. To run macros,
you need to reopen this workbook, and then choose to enable macros.
I dont get any alert to enable or disable macros when open any excel files.
I have also ticked €˜Trust access to the VBA project object model and chosen
€˜Enable all macros (not recommended, potentially dangerous code can run) by
taking following steps:
1. Click the Microsoft Office Button , and then click Excel Options.
2. Click Trust Center, click Trust Center Settings, and then click Macro
Settings.
I have password protected these Excel files - Does this stop running any
saved macros?
Also, if I link two files €“ save and close both then just open 1 of these,
it doesnt pick up the links/formulas and shows €˜#VALUE! for each cell,
until the other one is open too.
Please help