| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro autorunning
Hi
How can I get a certain macro run automaticly when selectin a certain worksheet? (excel 2003) rgds, Pekka |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro autorunning
Right click on the worksheet tabview codeleft window select
worksheetright window select activate. -- Don Guillett SalesAid Software "pjotr" wrote in message ... Hi How can I get a certain macro run automaticly when selectin a certain worksheet? (excel 2003) rgds, Pekka |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro autorunning
Thanks Don but still I have the same problem. The Macro (sub test()) do not
run automatically when selecting sheet2 unless I put put the macro in the sheet2 VBA-area. What did I do wrong? Pjotr "Don Guillett" kirjoitti: Right click on the worksheet tabview codeleft window select worksheetright window select activate. -- Don Guillett SalesAid Software "pjotr" wrote in message ... Hi How can I get a certain macro run automaticly when selectin a certain worksheet? (excel 2003) rgds, Pekka |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro autorunning
Pekka
Right-click on the sheet tab and "view code" Copy/paste this into the module. Private Sub Worksheet_Activate() your_macro_name End Sub Gord Dibben Excel MVP On Sun, 8 Aug 2004 10:33:02 -0700, "pjotr" wrote: Hi How can I get a certain macro run automaticly when selectin a certain worksheet? (excel 2003) rgds, Pekka |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro autorunning
Thanks Gord. now it works
"Gord Dibben" kirjoitti: Pekka Right-click on the sheet tab and "view code" Copy/paste this into the module. Private Sub Worksheet_Activate() your_macro_name End Sub Gord Dibben Excel MVP On Sun, 8 Aug 2004 10:33:02 -0700, "pjotr" wrote: Hi How can I get a certain macro run automaticly when selectin a certain worksheet? (excel 2003) rgds, Pekka |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Autorunning Macros | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
