LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Simple multi-password access

Hi guys,

I'd like to implement a simple multi-password access to the book just after
the book opens. It's a slight variation to the "Password to open" in the
"Save Options" dialog, which allows only a single password.

The book should always open to a sheet named: Table of Contents, with a
prompt to the user to enter a password, and click OK. The other button is
"Cancel" which closes the book.

The password entered will be matched against a list of authorised passwords
input in col A (in A1 down) in a (very?)hidden sheet. If the password
entered finds a match, then access to the book will be as per normal.

Appreciate any help / views. Thanks.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple ? countif, 3 separate conditions across multi tabs Steve Excel Worksheet Functions 8 January 3rd 09 05:59 AM
EXCEL ONLINE MULTI ACCESS Dave F Excel Discussion (Misc queries) 1 September 25th 06 11:56 AM
Multi-user access to Excel Bob Excel Discussion (Misc queries) 3 July 19th 06 10:07 PM
Multi users and linking to Access Ray Excel Discussion (Misc queries) 0 September 20th 05 03:15 AM
Restricting Multi-user access [email protected] Excel Worksheet Functions 0 June 17th 05 03:03 PM


All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"