Results 1 to 5 of 5

Adding a Password to Hyperlink button

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-14-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    120

    Adding a Password to Hyperlink button

    Dear All,

    I need help with hyperlink button and the possibility of linking a password to it.

    1. I have a workbook with two worksheets namely: INVOICE and PRODUCTS, respectively.

    2. The 'Invoice' worksheet has a hyperlink which, when clicked takes a user to the 'Products' worksheet. Also the 'Products' sheet has a hyperlink that takes a user back to the 'Invoice' sheet.

    3, When the file is initially opened, it is the Invoice sheet that shows. There is a small code that hides the other sheet when each of them is opened. And when the Invoice Sheet is opened, and the hyperlink on it is clicked, that action automatically activates the 'Products' sheet and take the user to the Products Sheet.

    4. However, we only want the Administrator and a few other authorized users to have access to both the 'Invoice' and 'Products' sheets. Other users are allowed to access and use the 'Invoice' sheet but not the 'Products' sheet.

    5. As indicated above, each of the sheets has a hyperlink link to each other.

    6. If it is possible, we want to attach a password requirement to the hyperlink button on the Invoice sheet that should take a user to the Products sheet. That is, if the hyperlink is clicked, it would ask for a password before being activated.

    7. We would very much like to achieve this. However, if this is not possible, we would appreciate a suggestion of another solution or approach that will enable us to achieve the same result of ensuring that to go from the Invoice Sheet to the Products sheet would require entering a password.

    I'll appreciate help with this, please.

    Buddy
    Last edited by Buddy8; 05-15-2016 at 12:41 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hyperlink password
    By MADA BLACK in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-11-2015, 07:21 PM
  2. [SOLVED] COmmand button requiring password, if password ok, unhide sheet.
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-04-2012, 09:43 AM
  3. User Password On A Button - Encrypt Password
    By mab in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2010, 08:10 AM
  4. Replies: 2
    Last Post: 02-09-2009, 05:07 AM
  5. Adding the Hyperlink funtiion to a button
    By penfold in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2008, 03:36 AM
  6. Password - hyperlink or macro?
    By Jonah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2005, 09:00 PM
  7. [SOLVED] Password hyperlink or macro?
    By Jonah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-27-2005, 02:45 PM

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