Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get my macro to appear in ALL worksheets
I have a macro that I want to be available in ALL workbooks/worksheets when
opened, even those worksheets emailed to me. Is there a excel.xlt standard template in excel2002 the same as a normal.dot templace in WORD ? How can I do this ? thanks .. Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get my macro to appear in ALL worksheets
Roger,
It's your PERSONAL.xls. It is hidden by default. NickHK "Roger Ottaway" wrote in message ... I have a macro that I want to be available in ALL workbooks/worksheets when opened, even those worksheets emailed to me. Is there a excel.xlt standard template in excel2002 the same as a normal.dot templace in WORD ? How can I do this ? thanks .. Roger |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get my macro to appear in ALL worksheets
Thanks, how can I find PERSONAL.xls, can I open it and store my macro in it?
thanks .. Roger "NickHK" wrote in message ... Roger, It's your PERSONAL.xls. It is hidden by default. NickHK "Roger Ottaway" wrote in message ... I have a macro that I want to be available in ALL workbooks/worksheets when opened, even those worksheets emailed to me. Is there a excel.xlt standard template in excel2002 the same as a normal.dot templace in WORD ? How can I do this ? thanks .. Roger |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get my macro to appear in ALL worksheets
Roger,
If you do not see in the VBA IDE, then in Excel go to WindowUnHide.. and select it. Then whenever you open Excel, code in it will be available to you. NickHK "Roger Ottaway" wrote in message ... Thanks, how can I find PERSONAL.xls, can I open it and store my macro in it? thanks .. Roger "NickHK" wrote in message ... Roger, It's your PERSONAL.xls. It is hidden by default. NickHK "Roger Ottaway" wrote in message ... I have a macro that I want to be available in ALL workbooks/worksheets when opened, even those worksheets emailed to me. Is there a excel.xlt standard template in excel2002 the same as a normal.dot templace in WORD ? How can I do this ? thanks .. Roger |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get my macro to appear in ALL worksheets
Hi Roger,
As Nick says you need to put your code into your personal.xls file. This file may not be available in which case you create a file by that name (Open an new work sheet Click file Save as) If you are using windows XP / 2000 you should save the file to C:\Documents and Settings\*Your Username*\Application Data\Microsoft\Excel\XLSTART (Any file place in this folder will start when excel starts). If Win9x / NT save to C:\Program Files\Microsoft Office\OFFICE\XLSTART Regards Paul "Roger Ottaway" wrote in message ... I have a macro that I want to be available in ALL workbooks/worksheets when opened, even those worksheets emailed to me. Is there a excel.xlt standard template in excel2002 the same as a normal.dot templace in WORD ? How can I do this ? thanks .. Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Worksheets Macro | Excel Worksheet Functions | |||
macro to all worksheets | New Users to Excel | |||
Run Macro for all worksheets | Excel Worksheet Functions | |||
Same macro - Different Worksheets!? | Excel Discussion (Misc queries) | |||
Macro for several worksheets | Excel Programming |