View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sonicscooter sonicscooter is offline
external usenet poster
 
Posts: 44
Default Macro's, Buttons, and 2 Instances

Hi, i have had for the last few month two instances of Excel running, with
the same buttons on the excel menu bar appearing on both instances as you
would expect, i asighned a macro to button 1, for the first instanse and it
works, i can't remember how i get the same button with the same macro to work
when i use the second instance, ie the same button doing the same thing in
each instance.

If i asighn a macro to button 1 in each instance when they are both open and
im using them both it works with both instances until i close them down, on
reopening only 1 button will work with 1 instance, if i click the button in
the other instance a box comes up saying that the macro's are not enabled and
refers to the other instances file.

I hope this makes sence, as i have now forgotten comlpetely how to solve
this problem...

Thanks Shane.