Thread: Commandbutton
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
david fixemer david fixemer is offline
external usenet poster
 
Posts: 4
Default Commandbutton

Ladies and Gentlemen,

I have a macro button that is installed when the my
workbook opens. Click on the button and viola, the macro
executes.

I would like to have this macro reside in my
personal.xls file. Therefore, I copied it over and closed
the original workbook. However, when I click the button,
the first workbook, which is now closed, opens and the
code executes on that workbook. How would I make the
button run "macro1" no matter which workbook is open I
want it to find the first and only occurance of macro1
among the open workbook(s) and execute that one?

Thanks in advance,

David Fixemer