I have a macro named "x" that i want to execute automatically when file
"panel.xls" is opened. Is that possible? any suggestions on how to do it?

--
dr chuck

Hi Dr Chuck,

Try :

'=============
Private Sub Workbook_Open()
Call X
End Sub
'<<=============

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module *not* a standard module or a sheet module:

Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)
Select 'View Code' from the menu and paste the code.
Alt-F11 to return to Excel.

---
Regards,
Norman



"dr chuck" wrote in message
...
I have a macro named "x" that i want to execute automatically when file
"panel.xls" is opened. Is that possible? any suggestions on how to do it?

--
dr chuck

In a general module:

Sub Auto_open()
mymacroname 'change
End sub
or

Private Sub Workbook_Open()
mymacroname 'change
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 maximize your workbooks),
select View Code from the menu, and paste the code

Mike F
"dr chuck" wrote in message
...
I have a macro named "x" that i want to execute automatically when file
"panel.xls" is opened. Is that possible? any suggestions on how to do it?

--
dr chuck

thanks for the info.
i am totally unfamiliar with workbook event code but will give it a shot.
--
dr chuck


"Norman Jones" wrote:

Hi Dr Chuck,

Try :

'=============
Private Sub Workbook_Open()
Call X
End Sub
'<<=============

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module *not* a standard module or a sheet module:

Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)
Select 'View Code' from the menu and paste the code.
Alt-F11 to return to Excel.

---
Regards,
Norman



"dr chuck" wrote in message
...
I have a macro named "x" that i want to execute automatically when file
"panel.xls" is opened. Is that possible? any suggestions on how to do it?

--
dr chuck

thanks for your help. I am totally unfamiliar with workbook event code but i
will give it a shot.

--
dr chuck


"Mike Fogleman" wrote:

In a general module:

Sub Auto_open()
mymacroname 'change
End sub
or

Private Sub Workbook_Open()
mymacroname 'change
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 maximize your workbooks),
select View Code from the menu, and paste the code

Mike F
"dr chuck" wrote in message
...
I have a macro named "x" that i want to execute automatically when file
"panel.xls" is opened. Is that possible? any suggestions on how to do it?

--
dr chuck

Hi Dr Chuck,

i am totally unfamiliar with workbook event code but will give it a shot.

Since you are unfamiliar with event procedures, for an overview see Chip
Pearson's Events page at:

http://www.cpearson.com/excel/events.htm



--
Regards,
Norman