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/

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/

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/