Password Setting

[VBALearner]

hi hi, it is so nice to have this forum...

I have a query on VBA programming regarding password setting. How to
set up a password when opening a file. good to have expiry date!! I
tried once before to write a macro to lock the file. However, if the
user choose "disable macros", then it does not work! Is there any way
out?? I know there is a built-in funtion in Excel to protect a file
from reading or writing upon opening. But there is no expiry date
attached!! thank you for yr help!!!

 

[Vasant Nanavati]

However, if the
user choose "disable macros", then it does not work! Is there any way
out??

Not really.

 

[Piranha]

VBALearner,
You could force the user to enable macros, by having the workbook auto
close
if the macros are not enabled..

Here is one way.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=578

 

[Piranha]

Gareth,
Yeah i didn't express my self very well did i. (You could force th
user to enable macros,
by having the workbook auto close if the macros are not enabled..)
Pretty much common sense huh.

What i was thinking and what i wrote weren't coordinated

I have a few workbooks set up like you describe, they work well.

Thanks for correcting my post, don't want to give bad info.

 

[VBALearner]

Dear Dave,Gareth,Piranha & Vasant

Thank you so much for yr advice or info. It helps me a lot....

 

[Gareth]

I couldn't agree more - getting down what's in your head just doesn't
happen sometimes - even when you read it back to yourself it looks
ok.... until you've posted it that is... *then* you realise!

;-)