Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create "permanent" toolbars
I was just upgraded from Office 2000 to Office 2003 here at work. (I
know, this is the state!) In XL2000, I could create tools and put them on the standard toolbar permanently, but I can't seem to do this with XL2003. I think it's because it now longer calls for the "PERSONAL" workbook where all the macros behind the buttons lived. Is there a workaround for this? If I can't get the tools in the existing toolbars, can I make a custom toolbar that automatically comes up when I open XL? Thanks again. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create "permanent" toolbars
Put your macros in a new workbook.
Use code to create the toolbar when that workbook opens. Save the workbook as an add-in and load through ToolsAdd-ins. For code to create a Toolbar see Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar02.html John Walkenbach's menumaker workbook is also a good source for creating toolbars. http://j-walk.com/ss/excel/tips/tip53.htm Gord Dibben MS Excel MVP On Mon, 29 Dec 2008 07:50:03 -0800 (PST), davegb wrote: I was just upgraded from Office 2000 to Office 2003 here at work. (I know, this is the state!) In XL2000, I could create tools and put them on the standard toolbar permanently, but I can't seem to do this with XL2003. I think it's because it now longer calls for the "PERSONAL" workbook where all the macros behind the buttons lived. Is there a workaround for this? If I can't get the tools in the existing toolbars, can I make a custom toolbar that automatically comes up when I open XL? Thanks again. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create "permanent" toolbars
On Dec 29, 9:17*am, Gord Dibben <gorddibbATshawDOTca wrote:
Put your macros in a new workbook. Use code to create the toolbar when that workbook opens. Save the workbook as an add-in and load through ToolsAdd-ins. For code to create a Toolbar see Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar02.html John Walkenbach's menumaker workbook is also a good source for creating toolbars. http://j-walk.com/ss/excel/tips/tip53.htm Gord Dibben *MS Excel MVP On Mon, 29 Dec 2008 07:50:03 -0800 (PST), davegb wrote: I was just upgraded from Office 2000 to Office 2003 here at work. (I know, this is the state!) In XL2000, I could create tools and put them on the standard toolbar permanently, but I can't seem to do this with XL2003. I think it's because it now longer calls for the "PERSONAL" workbook where all the macros behind the buttons lived. Is there a workaround for this? If I can't get the tools in the existing toolbars, can I make a custom toolbar that automatically comes up when I open XL? Thanks again.- Hide quoted text - - Show quoted text - Thanks for the reply. They've sure figured out how to make it way more complicated, haven't they? Another M$ dehancement to Office 2003! Happy Holidays. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
Making UserForm Values "Permanent" | Excel Programming |