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.
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.