Run macro automatically.
 

How do I make a macro run automatically when a worksheet it is attached to is
loaded?

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?

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?

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?

You said worksheet. To us that means each tab within the workbook which is
the file....

--
Don Guillett
SalesAid Software

"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?

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?

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?

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?