Enable Macro

[Anna]

My pop up message didn't appear when I open my workbook, I
guess my workbook macro was disable. How to enable macro?
thanks,

 

[mangesh_yadav]

If all your code is correct, then the problem lies with the securit
settings. Click on Tools > Macro > Security.
Select Medium. Click ok. Save and close

Next time when you open the workbook, you will get a pop-up askin
whether to enable or disable macros. Click on enable. This will soalv
your problem.

manges

 

[Alan]

Anna,
Its best to keep your questions in one message or thread only, this is
referring to your earlier message 'Pop Up Message' I believe. Gord and I
have given advice which will work ok if properly entered. This message will
only waste peoples time as they have no knowledge of the original question,
Regards,
Alan.

 

[Gord Dibben]

Alan

Perhaps Anna had the code replicated in the proper place(ThisWorkbook) but had
security set at "High".

I never addressed that in my first post.

Gord

 

[Anna]

It's working now. Thank you All (mangesh, Alan and Gord).