| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I control Macro run automatically current worksheet?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add a worksheet automatically using macro in xls? | Excel Worksheet Functions | |||
| Macro add worksheet to workbook automatically | Excel Discussion (Misc queries) | |||
| Run macro automatically on opening of worksheet | Excel Worksheet Functions | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| Macro to hide the current worksheet. | Excel Programming | |||
Linear Mode
