+ Reply to Thread
Results 1 to 2 of 2

No entry to a sheet without a password

  1. #1
    Forum Contributor
    Join Date
    08-24-2006
    Location
    Sevenoaks, Kent
    MS-Off Ver
    Office 365 ProPlus
    Posts
    459

    No entry to a sheet without a password

    Hi all

    I have a workbook with information on it open to everyone, but within this information there is a worksheet that i want only certain individuals to go into, what i want is when you press the tab at the bottom or the hyperlink that takes you to this page for a password request before you can see the information, CAN THIS BE DONE?

    Thanks

    DJ
    Last edited by djfatboyfats; 12-06-2008 at 07:26 AM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello djfatboyfats,

    Place you code to ask for and validate the password in the Worksheet_Activate() event procedure for the sheet in question.

    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1