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: 47
Default Assigning macros to buttons on a custom toolbar

This is a weird problem that seemed to pop up after users were upgraded to
Office 2003. The template was developed in Excel 2003 and seemed to work fine
when users had Office 2k. After users were upgraded, all macros assignments
somehow changed to obsolete versions of the template each time a user would
open it from either a netshare location I placed the file at or from an email
I attached the file to.

I changed the template to a regular workbook and updated all macro
assignments to the toolbar buttons. Some problem from the .xls.

I went to the user's office and loaded in the workbook and the buttons did
not work. I checked the macro list and there were double the amount of macros
listed. I check ed the Window drop-down and somehow an old copy of the
template was also loaded even though I had not opened it.

I searched the harddrive and found a few old versions of the template and
workbook which I deleted. Then I reassigned the macros to the buttons on the
user's machine and it works fine. But when she forwarded it to the next user,
they experienced the same thing, the buttons did not work because they were
referencing old versions of the workbook.

This workbook will be used across the country and I won't be able to go
around to reassign the macros on each of the users' machines.

When I assigned the macros, I selected "this workbook" to assign the macro
to. When this issue started I tried to reassign the macros to "file.name",
but that did not work. However, during the 'original' development, I may have
forgot to set that parameter and left it on the default 'All Open Workbooks'.
Could this be the reason the macros are referencing old versions? Doesn't
selecting "New" start a fresh workbook without any references to user
workbooks?

Thanks for any insight!
Jack

 
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
Assigning Macros to Toolbar buttons JMay Excel Discussion (Misc queries) 1 July 24th 07 07:22 PM
Assigning Macros to Buttons Christine Excel Discussion (Misc queries) 1 May 11th 06 09:42 PM
Assigning Macros to Toolbar buttons VBA Fun Excel Programming 2 May 25th 05 12:44 PM
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! Kevin Waite Excel Programming 2 March 3rd 04 03:31 PM
assigning macros to several custom buttons Greg Wilson[_3_] Excel Programming 0 August 12th 03 11:52 PM


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