New poster here. I found a solution from this website for my problem, but I have yet to implement. There are a few additional factors for my problem so I would like to design knowing whether it will work as intended. Keep in mind I'm 100% new to VBA, macros. So I may have other problems.

Here's my problem: I want users to be able to view only their data, based off of a drop down menu. They each need to have their own password. BUT, there are a few users who are able to see ALL data.

This is the "Macro" solution posted by another user in a different thread for reference:

Option Explicit
Const Mike As String = "Mike1"
Const Alan As String = "Alan1"
Const Bob As String = "Bob1"
Const Pete As String = "Pete1"

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
Dim pwd As String
Dim Oops As Boolean

Application.EnableEvents = False

For Each cell In Target
    If Not Intersect(cell, Range("B7")) Is Nothing And cell <> "" Then
        pwd = Application.InputBox("Password for " & cell & ":", _
                    "Enter Password", Type:=2)
        Select Case cell.Value
            Case "Mike"
                If pwd <> Mike Then Oops = True
            Case "Bob"
                If pwd <> Bob Then Oops = True
            Case "Alan"
                If pwd <> Alan Then Oops = True
            Case "Pete"
                If pwd <> Pete Then Oops = True
        End Select
        
        If Oops Then
            MsgBox "Bad password"
            cell = ""
        End If
    End If
Next cell

Application.EnableEvents = True
End Sub
I want users that have privilege to see all stores to still have the option to view stores individually, so it won't suffice to simply include an "All Stores" selection in my drop down menu.
If I provide these users with a password to unlock the sheet entirely from the Review tab, will it remove the prompt for passwords in the drop down menu?

I suppose it's possible to set up two passwords for each store, one a master password, but I don't want the end user to be prompted with a password each time they want to switch their store view.

All ideas appreciated.