View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ASU ASU is offline
external usenet poster
 
Posts: 63
Default Enable macro on opening workbook

OK. Having problems. When I open the workbook, I get a popup asking me enable
or diseable macro. How do I get it to enable macro automatically without
asking me.
--
ASU


"ASU" wrote:

Obrigado!
Ill see if it works
--
ASU


"Marcelo" wrote:

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