Workbook access control

[Skyhook]

Hi
Is there a way to have a workbook ask for a password after it has been accessed more than 3 times? If the correct password is entered then the userform will display and if not then the workbook will close. And if so how would you go about doing this.

Thanks in advance

 

[Legacy 98055]

Yes
Store your workbook open count in some inconspicuous cell and increment it every time the work book is opened. If it >=3 then prompt for the password.
On workbooks such as these, I hide all of my sheets except one which has no use except to display a simple message "macros must be enabled to use this workbook", if the correct password is supplied, the sheets are all unhidden and available for use.
Tom
This message was edited by TsTom on 2002-04-11 11:28