Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a global change of Hyperlink addresses? | Excel Discussion (Misc queries) | |||
group workbooks/files to make global changes? | New Users to Excel | |||
How to make global changes to charts | Charts and Charting in Excel | |||
Global Macro | Excel Discussion (Misc queries) | |||
Global Macro | New Users to Excel |