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:)


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

Automatic running of Macros
 

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"
wrote in message
...

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

Automatic running of Macros
 

Thanks Bob,

It helps a lot.

Thanks again. .. :)


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