How do I make a 'global' macro?
 

I'm sorry if this is a stupid question. I know how to move code from one
workbook to another, but I don't know how to move it to the global template
so it's always available for every workbook.

How can I do that? I looked in the help and couldn't find it. Maybe I didn't
know what to search under...

Thanks for any help,
Colin

How do I make a 'global' macro?
 

Macros available "full-time" reside in your "Personal.xls" file to be found
in your XLstart
folder. Open Excel at the menu, select WIndows Unhide {Select personal}
and OK
Alt-F11 to get to the VBE and put your macro code in a standard module.
Save, Close
VBE Window; then Windows Hide Personal. Close Personal - answer Yes to save.
Quit Excel, then reopen Excel - your macro should be available.


"Colin Higbie" wrote in message
...
I'm sorry if this is a stupid question. I know how to move code from one
workbook to another, but I don't know how to move it to the global
template
so it's always available for every workbook.

How can I do that? I looked in the help and couldn't find it. Maybe I
didn't
know what to search under...

Thanks for any help,
Colin

How do I make a 'global' macro?
 

I believe you could put it in any workbook -- i.e. the name doesn't have to be
Personal.xls -- as long as it is in the XLSTART directory so it loads
automatically, and you either set a reference to it from the VB editor, or you
use the workbook name with the function name.


On Thu, 4 Nov 2004 19:29:11 -0500, "Jim May" wrote:

Macros available "full-time" reside in your "Personal.xls" file to be found
in your XLstart
folder. Open Excel at the menu, select WIndows Unhide {Select personal}
and OK
Alt-F11 to get to the VBE and put your macro code in a standard module.
Save, Close
VBE Window; then Windows Hide Personal. Close Personal - answer Yes to save.
Quit Excel, then reopen Excel - your macro should be available.


"Colin Higbie" wrote in message
...
I'm sorry if this is a stupid question. I know how to move code from one
workbook to another, but I don't know how to move it to the global
template
so it's always available for every workbook.

How can I do that? I looked in the help and couldn't find it. Maybe I
didn't
know what to search under...

Thanks for any help,
Colin

How do I make a 'global' macro?
 

There was no Personal.xls file in the XLStart folder. I created it, now it
opens as a workbook every time I start Excel. It did successfully globally
enable the macro, as you said.

How do I get the macro without the rest of the workbook?

Thanks,
Colin


"Jim May" wrote in message news:wPzid.4$C%4.1@lakeread04...
Macros available "full-time" reside in your "Personal.xls" file to be
found
in your XLstart
folder. Open Excel at the menu, select WIndows Unhide {Select personal}
and OK
Alt-F11 to get to the VBE and put your macro code in a standard module.
Save, Close
VBE Window; then Windows Hide Personal. Close Personal - answer Yes to
save.
Quit Excel, then reopen Excel - your macro should be available.


"Colin Higbie" wrote in message
...
I'm sorry if this is a stupid question. I know how to move code from one
workbook to another, but I don't know how to move it to the global
template
so it's always available for every workbook.

How can I do that? I looked in the help and couldn't find it. Maybe I
didn't
know what to search under...

Thanks for any help,
Colin

How do I make a 'global' macro?
 

Colin

Select Personal.xls from Window and "Hide".

Close Excel and when asked click "yes" to "do you wnat to save changes etc."

Peronal.xls will now open "hidden" when you start Excel.

Gord Dibben Excel MVP

On Fri, 5 Nov 2004 19:23:36 -0500, "Colin Higbie"
wrote:

There was no Personal.xls file in the XLStart folder. I created it, now it
opens as a workbook every time I start Excel. It did successfully globally
enable the macro, as you said.

How do I get the macro without the rest of the workbook?

Thanks,
Colin


"Jim May" wrote in message news:wPzid.4$C%4.1@lakeread04...
Macros available "full-time" reside in your "Personal.xls" file to be
found
in your XLstart
folder. Open Excel at the menu, select WIndows Unhide {Select personal}
and OK
Alt-F11 to get to the VBE and put your macro code in a standard module.
Save, Close
VBE Window; then Windows Hide Personal. Close Personal - answer Yes to
save.
Quit Excel, then reopen Excel - your macro should be available.


"Colin Higbie" wrote in message
...
I'm sorry if this is a stupid question. I know how to move code from one
workbook to another, but I don't know how to move it to the global
template
so it's always available for every workbook.

How can I do that? I looked in the help and couldn't find it. Maybe I
didn't
know what to search under...

Thanks for any help,
Colin

How do I make a 'global' macro?
 

Excellent, it worked!

Thanks so much.

Cheers,
Colin


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Colin

Select Personal.xls from Window and "Hide".

Close Excel and when asked click "yes" to "do you wnat to save changes
etc."

Peronal.xls will now open "hidden" when you start Excel.

Gord Dibben Excel MVP

On Fri, 5 Nov 2004 19:23:36 -0500, "Colin Higbie"
wrote:

There was no Personal.xls file in the XLStart folder. I created it, now it
opens as a workbook every time I start Excel. It did successfully globally
enable the macro, as you said.

How do I get the macro without the rest of the workbook?

Thanks,
Colin


"Jim May" wrote in message news:wPzid.4$C%4.1@lakeread04...
Macros available "full-time" reside in your "Personal.xls" file to be
found
in your XLstart
folder. Open Excel at the menu, select WIndows Unhide {Select
personal}
and OK
Alt-F11 to get to the VBE and put your macro code in a standard module.
Save, Close
VBE Window; then Windows Hide Personal. Close Personal - answer Yes to
save.
Quit Excel, then reopen Excel - your macro should be available.


"Colin Higbie" wrote in message
...
I'm sorry if this is a stupid question. I know how to move code from
one
workbook to another, but I don't know how to move it to the global
template
so it's always available for every workbook.

How can I do that? I looked in the help and couldn't find it. Maybe I
didn't
know what to search under...

Thanks for any help,
Colin