Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
#1) value vs. formula #2) personal.xls and xlstart pathway | Excel Programming | |||
Shortcut to personal.xls in XLStart forlder | Excel Programming | |||
Multiple users running macro from personal.xls | Excel Programming |