| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel files - macros & links
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel files - macros & links
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel files - macros & links
Thank you very much. It worked.
Please any advise 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. I even tried saving both xlsm - but still the same error Thanks in advance "Ron de Bruin" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel files - macros & links
Click The Office Button- Excel Options - Advanced - then make sure "Update
links to other documents" is checked "Salman" wrote: Thank you very much. It worked. Please any advise 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. I even tried saving both xlsm - but still the same error Thanks in advance "Ron de Bruin" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel files - macros & links
Thanks.
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 "Salman" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making macros available to other excel files | Excel Discussion (Misc queries) | |||
| Links to html files in Excel? | Excel Discussion (Misc queries) | |||
| Can't Open Excel Files with Macros | Excel Discussion (Misc queries) | |||
| Updating Links to Other Excel Files | Excel Worksheet Functions | |||
| E-mailing links to Excel files | Excel Discussion (Misc queries) | |||
Linear Mode
