A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do we get 2003 .xlb toolbars and custom macros to show in 07



 
 
Thread Tools Display Modes
  #1  
Old June 6th, 2010, 12:23 AM posted to microsoft.public.excel.misc
bigdeal
external usenet poster
 
Posts: 1
Default how do we get 2003 .xlb toolbars and custom macros to show in 07

I have custom macros that are saved in an .xls file under the XLStart/ folder
in Excel 2003. These macros are referenced by an Excel11.xlb file that holds
the toolbars. All of these automatically open because they are under the
XLStart/ folder. How do I get them into Excel 2007 so they will open
automatically and how can I get the custom toolbar file to show up.
  #2  
Old June 6th, 2010, 01:24 AM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default how do we get 2003 .xlb toolbars and custom macros to show in 07

I would drop the toolbar file and create that toolbar on the fly when excel
opens the .xls file. It'll make things much easier.

Saved from a previous post:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/ar...me-simple.aspx

bigdeal wrote:

I have custom macros that are saved in an .xls file under the XLStart/ folder
in Excel 2003. These macros are referenced by an Excel11.xlb file that holds
the toolbars. All of these automatically open because they are under the
XLStart/ folder. How do I get them into Excel 2007 so they will open
automatically and how can I get the custom toolbar file to show up.


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.