If you are asking how to refer to a worksheet with the same name in several
different workbooks, then you would include the workbook name also:

Workbooks ("MyBook").Worksheets ("Template")
Workbooks ("MyBook2").Worksheets ("Template")
Workbooks ("MyBook3").Worksheets ("Template")
etc...
Mike F
"Jaan" wrote in message
...
Hi All

How can I create macro if worksheet name is ex."Template" before closing
workbook? I use this sheetname in more then ten workbooks

Best regards