Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Run macro automatically.
How do I make a macro run automatically when a worksheet it is attached to is
loaded? |
#2
|
|||
|
|||
right click on the sheet tabview codeleft window worksheetright window
activate -- Don Guillett SalesAid Software "Excel macro" <Excel wrote in message ... How do I make a macro run automatically when a worksheet it is attached to is loaded? |
#3
|
|||
|
|||
I am unable to find "activate " when I right click on worksheet. ( i assume
that you are referring to the windows explorer kind of interface which opens up on the left of the visula basic window) . Sorry! I am new to excel and many thanks for your quick response. "Don Guillett" wrote: right click on the sheet tabview codeleft window worksheetright window activate -- Don Guillett SalesAid Software "Excel macro" <Excel wrote in message ... How do I make a macro run automatically when a worksheet it is attached to is loaded? |
#4
|
|||
|
|||
Hi
See Chip Pearson's site for more info http://www.cpearson.com/excel/events.htm Example code : Sub Auto_open() MsgBox "Hi" End Sub Must be in a normal module If you use a Auto_open macro then this wil not run if you open the file with a macro Or a event Private Sub Workbook_Open() 'macro name or code End Sub Right click on the Excel icon next to File in the menubar And choose View code You are now in the Thisworkbook module Paste the Event in this place Alt-Q to go back to Excel Save and close the file -- Regards Ron de Bruin http://www.rondebruin.nl "Sheela" wrote in message ... I am unable to find "activate " when I right click on worksheet. ( i assume that you are referring to the windows explorer kind of interface which opens up on the left of the visula basic window) . Sorry! I am new to excel and many thanks for your quick response. "Don Guillett" wrote: right click on the sheet tabview codeleft window worksheetright window activate -- Don Guillett SalesAid Software "Excel macro" <Excel wrote in message ... How do I make a macro run automatically when a worksheet it is attached to is loaded? |
#6
|
|||
|
|||
Thanks a bunch...It works. Also how do I make the macro run automatically
whenever the value in a cell changes? "Ron de Bruin" wrote: Hi See Chip Pearson's site for more info http://www.cpearson.com/excel/events.htm Example code : Sub Auto_open() MsgBox "Hi" End Sub Must be in a normal module If you use a Auto_open macro then this wil not run if you open the file with a macro Or a event Private Sub Workbook_Open() 'macro name or code End Sub Right click on the Excel icon next to File in the menubar And choose View code You are now in the Thisworkbook module Paste the Event in this place Alt-Q to go back to Excel Save and close the file -- Regards Ron de Bruin http://www.rondebruin.nl "Sheela" wrote in message ... I am unable to find "activate " when I right click on worksheet. ( i assume that you are referring to the windows explorer kind of interface which opens up on the left of the visula basic window) . Sorry! I am new to excel and many thanks for your quick response. "Don Guillett" wrote: right click on the sheet tabview codeleft window worksheetright window activate -- Don Guillett SalesAid Software "Excel macro" <Excel wrote in message ... How do I make a macro run automatically when a worksheet it is attached to is loaded? |
#7
|
|||
|
|||
use a worksheet_CHANGE event
-- Don Guillett SalesAid Software "Sheela" wrote in message ... Thanks a bunch...It works. Also how do I make the macro run automatically whenever the value in a cell changes? "Ron de Bruin" wrote: Hi See Chip Pearson's site for more info http://www.cpearson.com/excel/events.htm Example code : Sub Auto_open() MsgBox "Hi" End Sub Must be in a normal module If you use a Auto_open macro then this wil not run if you open the file with a macro Or a event Private Sub Workbook_Open() 'macro name or code End Sub Right click on the Excel icon next to File in the menubar And choose View code You are now in the Thisworkbook module Paste the Event in this place Alt-Q to go back to Excel Save and close the file -- Regards Ron de Bruin http://www.rondebruin.nl "Sheela" wrote in message ... I am unable to find "activate " when I right click on worksheet. ( i assume that you are referring to the windows explorer kind of interface which opens up on the left of the visula basic window) . Sorry! I am new to excel and many thanks for your quick response. "Don Guillett" wrote: right click on the sheet tabview codeleft window worksheetright window activate -- Don Guillett SalesAid Software "Excel macro" <Excel wrote in message ... How do I make a macro run automatically when a worksheet it is attached to is loaded? |
#8
|
|||
|
|||
Hi sheela
See Chip's site look for the change event On this page you can see how you can use it http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Sheela" wrote in message ... Thanks a bunch...It works. Also how do I make the macro run automatically whenever the value in a cell changes? "Ron de Bruin" wrote: Hi See Chip Pearson's site for more info http://www.cpearson.com/excel/events.htm Example code : Sub Auto_open() MsgBox "Hi" End Sub Must be in a normal module If you use a Auto_open macro then this wil not run if you open the file with a macro Or a event Private Sub Workbook_Open() 'macro name or code End Sub Right click on the Excel icon next to File in the menubar And choose View code You are now in the Thisworkbook module Paste the Event in this place Alt-Q to go back to Excel Save and close the file -- Regards Ron de Bruin http://www.rondebruin.nl "Sheela" wrote in message ... I am unable to find "activate " when I right click on worksheet. ( i assume that you are referring to the windows explorer kind of interface which opens up on the left of the visula basic window) . Sorry! I am new to excel and many thanks for your quick response. "Don Guillett" wrote: right click on the sheet tabview codeleft window worksheetright window activate -- Don Guillett SalesAid Software "Excel macro" <Excel wrote in message ... How do I make a macro run automatically when a worksheet it is attached to is loaded? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Execute Macro automatically after hyperlink | Excel Discussion (Misc queries) | |||
Automatically run Macro | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
How can I set up a Macro to automatically run when I open a speci. | Excel Discussion (Misc queries) | |||
Automatically launch a macro when a fil is opened | Excel Discussion (Misc queries) |