Yes.. the Macro does exisit..

the error message says....

" Expected variable or procedure.. not module"

"Bob Phillips" wrote:

Do those macros exist? Did you store it where I suggested?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"flow23" wrote in message
...
I tried it.. but when I test it.. opening the file.. its gives error. .
and
opens the VBcode????

"Bob Phillips" wrote:


Private Sub Workbook_Open()
GetData
NameSheet
Extra
'[etc.
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

RP
(remove nothere from the email address if mailing direct)


"flow23" wrote in message
...
When I open the worksheet.. I want to execute few macros.. (name ...
Getdata
, namesheet ,extra)

what code do I tupe in the Worksheet_open?