Automatic running of Macros

[praveen_khm]

Hi all,

I have a simple query. I have created a macro. It needs a control key
to run. To put it more simple, it is a macro created manually and not
using the VB. Now, everytime I open the spreadsheet, I do not want the
macro to run with the control key. I want it to automatically run when
the sheet is open.

Can anyone please give me any suggestions on this please???

Thanks in advance,
Praveen

 

[Bob Phillips]

Private Sub Workbook_Open()
myMacro
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"praveen_khm" <[email protected]>
wrote in message
news[email protected]...

 

[praveen_khm]

Thanks Bob,

It helps a lot.

Thanks again. ..