View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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