Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom toolbar always available
Hi all
Would like to create custom toolbar with tools to open/close frequently used files Toolbar should always be avail on my laptop no matter what xl file I have open I created the toolbar, dropped a button on it, when prompted for macro occurred to me would only work if my personal.xls book where I store my frequently used macros is open. However, when I'm tiling, I like to close personal.xls o free up real estate. There must be a way around this as there are several buttons on the toolbars that work with no files open. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom toolbar always available
Why not just hide Personal.xls?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "goss " wrote in message ... Hi all Would like to create custom toolbar with tools to open/close frequently used files Toolbar should always be avail on my laptop no matter what xl file I have open I created the toolbar, dropped a button on it, when prompted for macro occurred to me would only work if my personal.xls book where I store my frequently used macros is open. However, when I'm tiling, I like to close personal.xls o free up real estate. There must be a way around this as there are several buttons on the toolbars that work with no files open. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom toolbar always available
your personal.xls doesn't have to be open, but if you press the button it
will open personal.xls to run the code. In otherwords, you can't run code in a closed workbook, but excel will open the workbook and run the macro if it knows where the workbook is. Code assigned to a command button does include the path to the workbook. -- Regards, Tom Ogilvy goss wrote in message ... Hi all Would like to create custom toolbar with tools to open/close frequently used files Toolbar should always be avail on my laptop no matter what xl file I have open I created the toolbar, dropped a button on it, when prompted for macro occurred to me would only work if my personal.xls book where I store my frequently used macros is open. However, when I'm tiling, I like to close personal.xls o free up real estate. There must be a way around this as there are several buttons on the toolbars that work with no files open. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom toolbar | Excel Discussion (Misc queries) | |||
Custom Toolbar | Excel Discussion (Misc queries) | |||
Custom toolbar in C# | Excel Programming | |||
Custom Toolbar | Excel Programming | |||
saving toolbar buttons on custom toolbar | Excel Programming |