Hi
maybe something like
If LCase(activeworkbook.name) = "template" then
'do something
end if

--
Regards
Frank Kabel
Frankfurt, Germany


Graham wrote:
Hi,

I am trying to perform a certain operation via AutoOpen
that will only run if the workbook name is "template" for
example. If the workbook name is anything else I would
like AutoOpen to ignore the procedure. I have been advised
to use Option Compare Text, but I don't know how! Help
please!

Thanks
Graham