Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 enabling macros
One of my main Excel 2003 spreadsheet runs on macros I wrote. I installed
Excel 2007 today, loaded the file.xls on it, the macros run. After saving in file.xlsm and reloading, the macros don't run anymore. The message is: "Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and choose to enable macros." I have set my macros at the lowest level in the 2007 trust center, as well as in Excel 2003. When I reopen the workbook, there is no option to "enable macros" Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 enabling macros
Hi Johan,
I experienced a similar problem when I upgraded. I think it might have been because I saved the workbook as xlsm before changing my security setting. Even after changing the security setting, I tried resaving as xlsm with the same filename but to no avail. Eventually I saved it to another new filename and closed the workbook and reopened it and hey presto it worked. I haven't bothered with any extensive testing of the above because I didn't experience the problems with any of the other files that I converted after changing my security settings. I have just assumed that the file was inheriting the security setting when it was initially saved and I couldn't get rid of that inherited setting unless I changed the filename and the problem was solved by saving after setting the security. I'll be interested to hear if it fixes the your problem. Regards, OssieMac "Johan U" wrote: One of my main Excel 2003 spreadsheet runs on macros I wrote. I installed Excel 2007 today, loaded the file.xls on it, the macros run. After saving in file.xlsm and reloading, the macros don't run anymore. The message is: "Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and choose to enable macros." I have set my macros at the lowest level in the 2007 trust center, as well as in Excel 2003. When I reopen the workbook, there is no option to "enable macros" Thanks for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 enabling macros
If the workbook requires a password to open (in other words is encrypted so
Excel cannot scan it) Excel disables the macros. -- Jim "Johan U" <Johan wrote in message ... One of my main Excel 2003 spreadsheet runs on macros I wrote. I installed Excel 2007 today, loaded the file.xls on it, the macros run. After saving in file.xlsm and reloading, the macros don't run anymore. The message is: "Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and choose to enable macros." I have set my macros at the lowest level in the 2007 trust center, as well as in Excel 2003. When I reopen the workbook, there is no option to "enable macros" Thanks for your help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 enabling macros
Thanks Ossie, thanks Jim. I made it work by removing the password.
It looks like the Excel upgrade with Windows XP doesn't appreciate passwords. I tried with Vista and it works fine... "OssieMac" wrote: Hi Johan, I experienced a similar problem when I upgraded. I think it might have been because I saved the workbook as xlsm before changing my security setting. Even after changing the security setting, I tried resaving as xlsm with the same filename but to no avail. Eventually I saved it to another new filename and closed the workbook and reopened it and hey presto it worked. I haven't bothered with any extensive testing of the above because I didn't experience the problems with any of the other files that I converted after changing my security settings. I have just assumed that the file was inheriting the security setting when it was initially saved and I couldn't get rid of that inherited setting unless I changed the filename and the problem was solved by saving after setting the security. I'll be interested to hear if it fixes the your problem. Regards, OssieMac "Johan U" wrote: One of my main Excel 2003 spreadsheet runs on macros I wrote. I installed Excel 2007 today, loaded the file.xls on it, the macros run. After saving in file.xlsm and reloading, the macros don't run anymore. The message is: "Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and choose to enable macros." I have set my macros at the lowest level in the 2007 trust center, as well as in Excel 2003. When I reopen the workbook, there is no option to "enable macros" Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Enabling Macros | Excel Discussion (Misc queries) | |||
Enabling Visual Basic in Excel 2007 | Excel Discussion (Misc queries) | |||
Enabling Macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Worksheet Functions |