Workbook access control

Skyhook · Apr 11th, 2002, 04:55 PM

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

Tom Schreiner · Apr 11th, 2002, 05:24 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 04:55 PM	#1
Skyhook Join Date: Apr 2002 Location: East Texas Posts: 38	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

Apr 11th, 2002, 05:24 PM	#2
Tom Schreiner Join Date: Mar 2002 Posts: 6,677	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 ]