sunday_storyteller
Board Regular
- Joined
- Jun 22, 2007
- Messages
- 51
All,
I have a Macro that I wrote that I need to be able to run. I am using Excel 2007. This workbook and macro were written in Excel 2007, and I saved the file as a "Macro Enabled Worksheet". The Macro was working fine before and after saving it.
When I opened the worksheet later today and tried to run that Macro, it says,
"Because of your Security settings, Macros have been disabled. To run macros, you need to re-open this workbook, and then choose to enable macros. For information about enabling macros, click Help."
I did click Help, and there was nothing useful there. (If their solution had worked, it would have been useful, but it did not.)
My security settings for Macros are currently "Disable all macros with notification."
It doesn't, however, give me an notification or choice to run the macros or not.
I need this macro to work, and one solution that I read (save the macro to your personal workbook and access that when you need it), I didn't even try because it is not an option. I need to be able to pass the Macro with the workbook to some other users.
Thanks in advance for any help. This is the first major problem I've encountered with Excel 2007, but it is an extremely annoying one.
I have a Macro that I wrote that I need to be able to run. I am using Excel 2007. This workbook and macro were written in Excel 2007, and I saved the file as a "Macro Enabled Worksheet". The Macro was working fine before and after saving it.
When I opened the worksheet later today and tried to run that Macro, it says,
"Because of your Security settings, Macros have been disabled. To run macros, you need to re-open this workbook, and then choose to enable macros. For information about enabling macros, click Help."
I did click Help, and there was nothing useful there. (If their solution had worked, it would have been useful, but it did not.)
My security settings for Macros are currently "Disable all macros with notification."
It doesn't, however, give me an notification or choice to run the macros or not.
I need this macro to work, and one solution that I read (save the macro to your personal workbook and access that when you need it), I didn't even try because it is not an option. I need to be able to pass the Macro with the workbook to some other users.
Thanks in advance for any help. This is the first major problem I've encountered with Excel 2007, but it is an extremely annoying one.