Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 9th 14, 09:58 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 9
Default Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7

The following are located correctly in the new computer:

Excel11.xlb in \Users\XXXX\AppData\Roaming\Microsoft\Excel
Personal.xls in \Users\XXXX\AppData\Roaming\Microsoft\Excel\XLSTAR T

The toolbar icons provided by Microsoft Excel work fine.

The problem--When I click on an icon with a macro that I wrote in the old computer, I get the following message:

The macro "C:\Users\XXXX\AppData\Roaming\Microsoft\Excel\XLS TART
\PERSONAL.XLS'!MY_MACRO' cannot be found."

For each of the icons with macros that I wrote, if I assign the macro name, with the same spelling, from the list provided by Excel in Personal.xls, it works. However, is there something I can do to make everything work at once?

Thanks!

  #2   Report Post  
Old March 10th 14, 12:48 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2011
Posts: 3,514
Default Error After Copying Excel 2003 Macros and Toolbars from Windows Vista to Windows 7

If your macros are fired from custom menus or custom toolbar then you
should destroy them at shutdown so they don't persist in the TLB. This
way, all you need to do is transfer your Personal.xls file.

Any custom menus/toolbars you create at startup will not persist when
another user runs Excel (AFAIK)! Better yet is to put your macros in an
addin if they need to be used by others.

I assume you know custom menus/toolbars appear on the Addins tab in
XL12 and later!<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion




Reply
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
VBE Toolbars and Windows BillCPA Excel Programming 2 March 11th 10 10:41 PM
i want all windows in one excel frame (windows in taskbar) Subramanya Excel Discussion (Misc queries) 1 December 18th 09 03:14 PM
2003 Excel Windows XP to 2007 Excel Windows Vista jadeB Excel Programming 1 August 11th 08 07:23 PM
Windows XP Office 2003 Run-time error '9' DUHAAS Excel Programming 2 May 6th 08 12:49 AM
Hiding toolbars but keeping the Windows Menu Bar? Big Chris[_28_] Excel Programming 1 January 9th 04 08:12 PM


All times are GMT +1. The time now is 02:15 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017