Seems that the WB created when you right clickNew, is located at
"C:\WINNT\ShellNew\EXCEL9.xls for me with Excel 2K.
You could modify that I suppose, by no will run when created, because is
only copied, not opened.

You can code to your Personal.xls, using Application Level Events to perform
actions whenever a WB is opened or New created through Excel.

Depends what you want to achieve.

NickHK

"karnek" wrote in
message ...

Hello,

I have default template with macro. When I open MS Excel and crete new
workbook the template is loaded, but when I create workbook be
right-click on destktop - New - New Microsoft Excel Worksheet, the
template is not loaded.

Can you help me with this problem. I need simply macro which is
activate always at each opened workbook.

Thanks in advance.

Karol Nekanovic


--
karnek
------------------------------------------------------------------------
karnek's Profile:
http://www.excelforum.com/member.php...o&userid=36570
View this thread: http://www.excelforum.com/showthread...hreadid=563151