Reg: Macro - Auto runSolved/Closed

Question

Hello,
  I need to run a macro automatically when i open an excel sheet.
      and aslo to run a macro when i close the sheet
  can any one help me in this.

regards
jee

venkat1926 · Answer

is it when you open the sheet or open the workbook

I assume when you activate a sheet.


right click the sheet tab and paste these two event codes 

Private Sub Worksheet_Activate()
macro name
End Sub


Private Sub Worksheet_Deactivate()
macro name 
End Sub

venkat1926 · Answer

not clear where was the problem.. was the original macro in standard module 
did you introduce the macro name in the space between the lines 


Private Sub Worksheet_Activate()

and 

end sub 

what is your macro. post the macro

and the module number in which the macro is parked.

venkat1926 · Answer

I tried in my excel 2002 it works. 

let us what could be the problem

go to some other sheet and then select sheet 
does this help 
If it does not 
goto vbeditor (alt+F11)
then in the vbe editor click view and click immediate window
in the immedite window pate 
application.enableevents=true 
and hit enteer key at the end of the above line. 
now again go someother sheet and again come back to sheet 1  

The logic is whever you select sheet 1 the macro m will operate. by merely staying in sheet 1 it will not operate. keep this in mind. \
confirm whether it is ok or still some problem.

venkat1926 · Answer

This is an event code. some event should happen. in this case it is activating a sheet. it can be double click or right click a cell or change in selection of a cell or change in the value of a cell  which event do you want the fire the macro?????
the events are:
    * Activate
     * BeforeDoubleClick
    * BeforeRightClick
    * Calculate
    * Change
    * Deactivate
    * SelectionChange

aquarelle · Answer

Hello,

To automatically run a macro when you open a workbook, you have to add in a module of your workbook (with your example here) :
Sub Auto_Open()
        Activesheet.cells(5,5).value = 67 
End Sub

Best regards

Reg: Macro - Auto run

5 responses

Similar discussions

Subscribe To Our Newsletter!