View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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!