View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gocush[_29_] gocush[_29_] is offline
external usenet poster
 
Posts: 252
Default Can I control Macro run automatically current worksheet?

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