Instead of references to a specific sheet,
Use Activesheet to refer to the sheet. Use ActiveWorkbook to refer to
workbook containing the currently active sheet.

--
Regards,
Tom Ogilvy

"Microlong" wrote in message
...
I run a Macro in Excel 2003 with VBA, I want to run this Macro the current
worksheet, not other worksheet, even if others worksheet is opening. Can
anyone know how to control this macro run automatically appointed
worksheet?
--
Developer
QA Dashboard
Microsoft China Development Centre