after closing and opening the worksheet the vba code not working

Hi
im working on excel 2007
i write the following code

Please Login or Register  to view this content.

and when i click save it givers me message inform that in order to save this feature you should save in macro-enabled file and i save it as macro enabled work sheet it gives me message says"privacy warning this document contains macro or web content that may include personal information that cannot be removed by the doument inspector" and i click yes

and test it and it works fine. then i close the work sheet and open it again and try to test that code i find that it doesn't work !!! although the code still found !!

any idea what wrong?

thanks in advance.

This works fine for me

Please Login or Register  to view this content.

I wouldb't use Sheets(1) though because if the tabs are re-arranged then it will refer to a different workbook. If the code refers to the sheet that holds the code then use

Please Login or Register  to view this content.

or if not use

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.