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: 3
Default Macros in a template run from Custom Toolbar attaching to wrong file.

I've created a Excel template with a number of macros to
run functions in this system. I've created a custom
toolbar to run a number of these macros. The problem
I've encountered is that the toolbar will become attached
to a workbook saved from this template and when the
template is opened next, the toolbar buttons cause the
old worksheet to open and the macros running from the
toolbar are in the old book and not the new one.

I've tried "attaching" the toolbar; opening and closing
the toolbar when the workbooks open and close; and
deleting the toolbar every time a workbook closes. None
of these things have solved the problem.

Does anyone have a fuller understanding of how to make a
custom toolbar run properly with templates and workbooks
created from this template?
 
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
Custom toolbar for template - macros not working Ann Scharpf Excel Discussion (Misc queries) 2 February 5th 07 10:54 PM
Source Excel Template Pops Up when using a custom toolbar Murray Excel Discussion (Misc queries) 3 December 7th 05 12:04 AM
Custom toolbar and macros MD Excel Discussion (Misc queries) 2 May 10th 05 05:31 PM
Custom Toolbar Macros Merlzie Excel Programming 1 October 14th 03 02:23 AM
Attaching Macros to Custom Buttons Jack O Excel Programming 0 August 21st 03 10:49 PM


All times are GMT +1. The time now is 11:33 PM.

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"