Create Workbook That Doesn't Show In Taskbar?

[MDW]

I've created a large number of macros that are stored in my personal.xls
file. I don't need access to all of them at any given time, so I'm trying to
find a way to remove some of them from my macros window and only display them
when I need to.

I know that I could save the macros in another workbook and just open that
workbook when I need the macros. However, this causes the new workbook to
appear in my Windows taskbar. I often have 15+ workbooks open at once, and
this is not ideal for me.

I tried saving my macros as an addin, but the macro names do not appear in
my Macros window after I add them. (This, according to the Help, is the way
it's supposed to work...?)

Is there a way to create a workbook that doesn't show up in your taskbar?

 

[Ron de Bruin]

Look at John's example to create a menu
http://www.j-walk.com/ss/excel/tips/tip53.htm

Add this line on top of your module to hide the macros in Alt-F8
Option Private Module

 

[MDW]

"Add this line on top of your module to hide the macros in Alt-F8
Option Private Module"

Ah, that'll work.

Thanks.

 

[Jon Peltier]

I never show all my workbooks in the taskbar. The taskbar is for other
tasks, and I can get to my workbooks using the Windows menu or Alt+Tab.

- Jon