Can I control Macro run automatically current worksheet?

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

Microlong

more details required

What is the trigger for running the macro

Paste some of your code so that we can see how you structure your code.

Is this to be run over just one sheet in one workbook

you could start you macro by activating the sheet you want ...or..

With Sheets("MySheet")
your code
End with

"Microlong" wrote:

> 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

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" <Microlong@email.com> wrote in message
news:6B6B56FD-8985-471D-ABE2-25828E448319@microsoft.com...
> 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