PASSWORD PROTECTION

[Kym]

Hi,
I am stuck and wondering if someone can help. I am trying protect a workbook in the following manner.
Allow users to simply open up the workbook until a certain date and then after that certain date I want them to have to enter a password to enter the workbook. Once this date occurs users wont be able to open the workbook unless they 1. Know the password or 2. I extend the date so they dont have to enter a password to enter.

Hope this makes sense - I have been searching the board for hours and cant seem to find what I want.

Thanks in advance

 

[golf401]

not sure if this works but i did find this thread

http://www.mrexcel.com/board2/viewtopic.php?t=72639&highlight=password+limit

 

[golf401]

heres another thread that shows more of the password coding

http://www.mrexcel.com/board2/viewtopic.php?t=59216&highlight=password+limit

 

[Kym]

Hi,
I am stuck and wondering if someone can help. I am trying protect a workbook in the following manner.
Allow users to simply open up the workbook until a certain date and then after that certain date I want them to have to enter a password to enter the workbook. Once this date occurs users wont be able to open the workbook unless they 1. Know the password or 2. I extend the date so they dont have to enter a password to enter.

Hope this makes sense - I have been searching the board for hours and cant seem to find what I want.

Thanks in advance

ray: