Can I control Macro run automatically current worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
you could start you macro by activating the sheet you want ...or..

With Sheets("MySheet")
your code
End with
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to call module function or sub from the Add In? 3
Run Macro If Cell have "x" value 0
macro to control tabs (different worksheets) 8
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to force macros refer to ActiveWorkbook 2
Need Macro... 8
Open Specific Worksheet Using Button Form Control in Excel 0
Auto Save 2

Back
Top