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
|