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/