Excel 2007-Saving as macro enabled file

I have created a spreadsheet that I want to send to various end users. The workbook contains 3 sheets. The first sheet is a welcome screen explaining the use of the spreadsheet. Additionally, I have written a macro assigned to a smiley that will take the user to the desired location on the second sheet. Certain cells are are also locked and the workbook is password protected to prevent altering. I have saved the workbook as a macro enabled file. However, when the file is opened, it says the macro is not contained in the workbook. I am sure it is something simple I have overlooked.

I would appreciate any help.

thx,
Stumped