Macro not running on workbook open...

Hello everyone....
I have a macro that should run on start up i.e. opening of workbook but it doesn't ....can someone figure out where I am probably going wrong??

Please Login or Register  to view this content.

These are two functions----

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The Workbook_Open sub should be in the ThisWorkbook module.

Two Possibilities:-

Macro may not be turned on while opening the file
Event may be turned OFF

Check this in immediate window

In VBA press Ctrl+G and enter

Please Login or Register  to view this content.

Press Enter and if it shows False then enter this to turn it ON

Please Login or Register  to view this content.

Press enter and close the file and reopen it and check

Edit:-
I have not seen your workbook at all lol

Hi sourabh,

The Event code must be behind the workbook module. I've move it there. Read about event code and module differences at:
http://www.cpearson.com/excel/Events.aspx

Thanks a lot to all of you ....I tried shifting the code to another module as I knew it had to be somewhere else...but forgot that it had to placed in this workbook...
Thanks a lot....