Automatic running of Macros

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

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" <praveen_khm.23iv1b_1140429001.9731@excelforum-nospam.com>
wrote in message
news:praveen_khm.23iv1b_1140429001.9731@excelforum-nospam.com...
>
> 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
>
>
> --
> praveen_khm
> ------------------------------------------------------------------------
> praveen_khm's Profile:
http://www.excelforum.com/member.php...o&userid=30364
> View this thread: http://www.excelforum.com/showthread...hreadid=514337
>

Thanks Bob,

It helps a lot.

Thanks again. ..