macros available in ALL spreadsheets

P

Pascale

Hello
I would like to have a specific macro to be available to whichever
spreadsheet I open. How would I go about this? I work with Excel 2003
Thanks
 
J

JMay

Under your Excel Program files there is a folder named XLStartUp
In that folder you can create a file named personal.xls
and in it (that is in the VBE portion of the file ONLY) and
whatever Macros (Usually (99%) in a Standard Module) - After
entering your Macros there Save Personal.xls (but first
Do a Window - Hide command) This way you never see it
but it is automatically load every time you open Excel - and
Macros THEREIN are available to you through out all your sessions.

You will have to Exit Excel after creating the file (If it doesn't
already exist) and re-open excel (to grab and open personal.xls)

HTH

Jim May
 
O

opieandy

I don't have a "personal.xls" file on my PC. Most of my macros work globally
in all workbooks (though the macro does not appear on a list when I open that
workbook, but the toolbar button operates the macro appropriately), however,
a couple of them only work by opening the specific file the macro was created
in. Without creating a "personal.xls" file, how can I get those two macros
to work globally? Any idea why most of them do work globally without
"personal.xls"? I can't even find where those global macros reside.
 
B

Bernie Deitrick

Right click a commandbar, select "Customize..." then right click the macro button and select "Assign
Macro..." and a dialog will come that will show the file name and macro name. It may be in an
add-in.... Look under Tools / Add-ins, and see if the file is refrenced there.

HTH,
Bernie
MS Excel MVP
 
O

opieandy

Bernie,

That was the first thing I tried. No macros are shown in the pop-up box.
It is a real mystery where the macros are residing and why they are working
without opening the workbook where they reside.

Chris
 
B

Bernie Deitrick

Chris,

So, just so I'm clear on what you mean, there is a commandbar button that launches a macro, but the
macro is not shown when using the "Customize..."/"Assign macro..." option on that button? Or are you
talking about the Tools/Macro... Macros Run macro dialog box?

Bernie
MS Excel MVP
 
Top