Hello,

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

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

Thanks in advance.

Karol Nekanovi

--
karne
-----------------------------------------------------------------------
karnek's Profile: http://www.excelforum.com/member.php...fo&userid=3657
View this thread: http://www.excelforum.com/showthread.php?threadid=56315

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

NickHK, thank you for your answer. It helped me with that issue.

But I recognized, that my default template works only with new WB an
when I open exist one the template is not loaded and active. I nee
that the template is loaded at each WB.

Could you please help me how can I do it?

Thanks in advance.

Karol Nekanovi

--
karne
-----------------------------------------------------------------------
karnek's Profile: http://www.excelforum.com/member.php...fo&userid=3657
View this thread: http://www.excelforum.com/showthread.php?threadid=56315

But if you are opening a file, that means that it already exists and could
be any style/layout/design.

I do not understand why you want to open a (new) template every time you
open any existing file.

Explain what you are trying to do.

NickHK

"karnek" wrote in
message ...

NickHK, thank you for your answer. It helped me with that issue.

But I recognized, that my default template works only with new WB and
when I open exist one the template is not loaded and active. I need
that the template is loaded at each WB.

Could you please help me how can I do it?

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