Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default XLStart is empty but Personal is still running - sort of

The toolbar has icons that point at macros in workbooks. If you move the
workbook, you'll have to reassign the macros to the new location.

Open the file with the macros.
Tools|Customize (Just to see the dialog)
rightclick on each of the icons|Assign macro and point to the new personal.xls.

=====
I think your life will be lots easier if you create that toolbar when the
workbook opens and destroy it when the workbook closes.

Some references if you want to look at that option:

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)

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

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

Martin Wheeler wrote:

<<snipped

I have just removed the XLStart folder and had Office CD repair excel. But
I moved the Personal file to My Documents whilst the repair was being done.
Now the toolbar cannot find the macros in the XLStart folder,Personal file
How do I redirect the buttons?


--

Dave Peterson
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
#1) value vs. formula #2) personal.xls and xlstart pathway Neal Zimm Excel Programming 2 September 19th 06 09:16 PM
Shortcut to personal.xls in XLStart forlder Jackie Excel Programming 1 November 3rd 04 08:59 PM
Multiple users running macro from personal.xls TP[_3_] Excel Programming 0 August 22nd 03 04:11 PM


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