Loading default template

[karnek]

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

 

[NickHK]

Seems that the WB created when you right click>New, 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]

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

 

[NickHK]

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