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?
--
Hmm...they have the Internet on COMPUTERS now!

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"MDW" wrote in message ...
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?
--
Hmm...they have the Internet on COMPUTERS now!

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

Ah, that'll work.

Thanks.

--
Hmm...they have the Internet on COMPUTERS now!


"Ron de Bruin" wrote:

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"MDW" wrote in message ...
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?
--
Hmm...they have the Internet on COMPUTERS now!

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"MDW" wrote in message
...
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?
--
Hmm...they have the Internet on COMPUTERS now!