LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
How do you assign macro's to new menu with buttons on Auto_open? Simon Lloyd[_514_] Excel Programming 6 June 27th 04 12:14 PM
How do you assign macro's to new menu with buttons on Auto_open? Simon Lloyd[_502_] Excel Programming 2 June 23rd 04 11:19 PM
Is there an easy way to replace list A instances with list B instances (sorted lists). kkip Excel Programming 3 December 31st 03 01:50 PM
Assigning Macro's to control buttons. catdataman Excel Programming 3 December 23rd 03 05:16 PM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"