P
petedavo
Consider the following scenario. You add a macro to the Quick Access Toolbar
in Microsoft Office Excel 2007. Then you close Excel 2007. Later, when you
are working in Excel 2007, you click the button for a macro. In this
scenario, you receive the following error message:
Cannot run the macro 'macroname'. The macro may not be available in this
workbook or all macros may be disabled
I looked at http://support.microsoft.com/kb/930076/en-us but it doesn't fix
my problem.
I copied the macro modules I created in Office 2003 personal.xls to Office
2007 personal.xlsb in the vba project.
Then I created buttons for each in the quick access toolbar.
But when I open a spreadsheet the buttons do not work and come back with the
error message "Cannot run the macro 'macroname'. The macro may not be
available in this workbook or all macros may be disabled"
I tried enabling all macro's to no effect.
I can run the macros fine, manually from Alt+F8 but this defeats the whole
purpose of having the macros in the first place (saves time).
If I unhide personal.xlsb the buttons then work, but there is good reason
for personal.xlsb to be hidden as I open 30 spreadsheets at a time and use
the macros to copy and past from these locked spreadsheets certain rows and
columns and then paste the values only into a master spreadsheet, and I don't
want to accidently paste something into personal.xlsb or in some other way
accidently copy from it either.
In 2003 this isn't an issue, buttons work fine. In 2007 however they don't
want to work!
in Microsoft Office Excel 2007. Then you close Excel 2007. Later, when you
are working in Excel 2007, you click the button for a macro. In this
scenario, you receive the following error message:
Cannot run the macro 'macroname'. The macro may not be available in this
workbook or all macros may be disabled
I looked at http://support.microsoft.com/kb/930076/en-us but it doesn't fix
my problem.
I copied the macro modules I created in Office 2003 personal.xls to Office
2007 personal.xlsb in the vba project.
Then I created buttons for each in the quick access toolbar.
But when I open a spreadsheet the buttons do not work and come back with the
error message "Cannot run the macro 'macroname'. The macro may not be
available in this workbook or all macros may be disabled"
I tried enabling all macro's to no effect.
I can run the macros fine, manually from Alt+F8 but this defeats the whole
purpose of having the macros in the first place (saves time).
If I unhide personal.xlsb the buttons then work, but there is good reason
for personal.xlsb to be hidden as I open 30 spreadsheets at a time and use
the macros to copy and past from these locked spreadsheets certain rows and
columns and then paste the values only into a master spreadsheet, and I don't
want to accidently paste something into personal.xlsb or in some other way
accidently copy from it either.
In 2003 this isn't an issue, buttons work fine. In 2007 however they don't
want to work!