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/

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/

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/