change the name of the macro to AUTOOPEN

eg
___________________________
Sub AutoOpen

your code

End Sub
___________________________

hth
regards from Brazil
Marcelo

"ASU" escreveu:

How can I automatically enable Macro on opening my workbook(which contains 7
worksheets).
--
ASU