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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create "permanent" toolbars
On Dec 29, 8:00*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Actually you can have a Personal.xls in 2003 and add buttons to the Toolbar. These customizations are saved in your Excel11.xlb file. I don't recommend going with that method due to a larger *.xlb file tending to become corrupt and cause problems. But you can still do it the way you did in Excel 2000 if you choose. Gord On Mon, 29 Dec 2008 12:28:24 -0800 (PST), davegb wrote: 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.- Hide quoted text - - Show quoted text - Thanks again, Gord. Think I'll do the extra steps and avoid the hassles later on. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create "permanent" toolbars
On Mon, 29 Dec 2008 19:00:24 -0800, Gord Dibben wrote:
Actually you can have a Personal.xls in 2003 and add buttons to the Toolbar. These customizations are saved in your Excel11.xlb file. I don't recommend going with that method due to a larger *.xlb file tending to become corrupt and cause problems. But you can still do it the way you did in Excel 2000 if you choose. Gord On Mon, 29 Dec 2008 12:28:24 -0800 (PST), davegb wrote: 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. Just to let you know, I finally got time to get to this and it worked fine. Made some mods to put the toolbar up adjacent to the formatting toolbar and also to get rid of that annoying "Reviewing" toolbar that XP wants up all the time. Thanks! |
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 |