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: 16
Default QAT Reference to Macros in Another Workbook Don't Stick

Running Excel 2007 under Vista. I have one workbook which will contain all
my data, and a second which contains a set of macros. By adding the second
workbook as a reference, I am able to access all of the macros from the
first. (I did have to add a dummy macro to the first workbook to get the
reference to stick.) I can add these macros to the Quick Access Toolbar in
the first workbook, and they work until I close the file; however, they are
gone when the file is re-opened. I can add my dummy macro from the first
file to the QAT, and that sticks. However, if I then add a macro from the
second workbook, both additions disappear on re-opening.

Any suggestions on how to make these QAT modifications stick?

George B.


 
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
Drop down list using macros in a personal macros workbook jlcoop01 Excel Programming 0 October 23rd 09 03:56 PM
Moving workbook to memory stick - hyperlinks fail Brucear Excel Discussion (Misc queries) 2 September 18th 06 12:32 AM
How to Delete Another WorkBook Macros using Macros.. Possible? ddiicc Excel Programming 7 July 24th 05 01:54 PM
Open workbook-macros enabled, opening another with macros George J Excel Programming 5 September 17th 04 02:07 PM
Workbook Reference for Macros Rich[_13_] Excel Programming 1 September 5th 03 10:42 PM


All times are GMT +1. The time now is 04:05 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"