Thread
:
cant run existing macros
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
cant run existing macros
John,
I have a macro tool bar with custom macro buttons
I assume that you mean that you have a custom toolbar. If that is the case
then you have to re-attach the toolbar to the workbook after altering it or
it will only retain the original toolbar.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"john mcmichael" wrote in message
...
I have a macro tool bar with custom macro buttons - all with macros
assigned.
All have worked well for me in the past. However, when I click one of the
buttons now, the macros do not run. I get an error that reads "
personal.xls
can not be found" When I open the VBE, the macros are still there and I
can
re-assign the macro to the buttons. But when I close the workbook and
reopen
MS Excel 2003, the macro buttons fail to retain the assigned macro. What
can
I do help the buttons remember that they are to run the assigned macro.
Thanks in advance for help...and have a great day!
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann