+ Reply to Thread
Results 1 to 2 of 2

Prompt password when specific dropbox value is selected

  1. #1
    Registered User
    Join Date
    06-19-2019
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    1

    Prompt password when specific dropbox value is selected

    First off VBA is not my strongest skill and I am having issues regarding a form with two main groups of users with different responsibilities for the form.

    I have a dropbox with 4 values to mark user changes.
    The options are "Edit User", "New User", "Term User" and "Current User".

    There is already some timestamp macros and locking macros on the worksheet. The main focus is when a individual attempts to change the dropbox value to "Current User", that it would prompt a password in order to make sure the correct people are verifying the change.

    Generally, this code works if hypothetically they double clicked to change, but doesn't offer much safety for a drop down.

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If cell.Value = "Current User" Then
    Dim pass As String
    pass = InputBox("Enter Password")
    If pass <> "Coleslaw1" Then
    MsgBox ("Wrong password")
    Else
    Sheets("Step 2 - Supervisor Assignment").Unprotect password:="password"
    Target.Locked = False
    End If
    End If
    End Sub


    Any ideas or workarounds?

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Prompt password when specific dropbox value is selected

    Change the "B3" to the cell that has the dropdown

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 04-17-2019, 03:35 AM
  2. Prompt for VBA Project password after Excel closes with Dropbox Badge
    By testter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2016, 10:13 PM
  3. [SOLVED] Password Prompt
    By billgyrotech in forum Excel General
    Replies: 14
    Last Post: 12-09-2015, 06:05 PM
  4. Excel VBA Code to upload a file to Dropbox using the Dropbox API
    By gb# in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 03:41 PM
  5. VBA code that bypass Password prompt for every workbook with one master password
    By pwnyadav007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2014, 01:45 AM
  6. [SOLVED] Password Prompt
    By Noel in forum Excel General
    Replies: 0
    Last Post: 05-18-2005, 03:06 PM
  7. Password Prompt
    By LuhElle in forum Excel General
    Replies: 2
    Last Post: 03-08-2005, 08:06 PM

Tags for this Thread

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