Thanks for the info. I have some code written that looks at the date and
if it is greater than a value I put in it then it deletes the sheet and
saves file. I'm really new at the VB side. Is there some code that looks
wether Macro's are Enabled? Again thanks for the help.

Brent


"JE McGimpsey" wrote in message
...
No.

You can do various things, such as hide your sheets and unhide them via
code (leaving a single splash sheet saying "You must enable macros").

But protection in XL is very weak. It's a matter of a minute or less to
remove all internal and VBA protection from a workbook, with the right
tools, so you can't force the user to do much of anything...


In article ,
"Brent" wrote:

Is there a way to force someone to enable Macro's before opening up an
Excel
file? I'm currently on Office XP. Thanks