Button Triggered Allow Edit Range with password with different password for each cells

S

studentlearner

New Member
Joined
Oct 7, 2021
Messages
30
Office Version
  1. 365
Platform
  1. Windows
Was planning on making a button that utilizes the allow edit range feature which once clicked it will.
1. Lock all cells with value.
2. Cell with value will each have different password. and the password will be the Queue ID (Example - row 2 will only be editable if keyed in password T13P001, the following will be diff).
3. lastly will most probably hide the Queue ID after the whole sequence.

Any help would be great! Thanks!!
Queue IDHighlight DishDay Dish FormulaNameManager
T13P001Formula 13JohnSenior
T13P002Formula 13JackSenior
T13P003Formula 13AlanSenior
T13P004Formula 13AdamJunior
T13P005Formula 13AllenJunior
T13P006Formula 13BenSenior
T50P007Formula 50BeckSenior
T50P008Formula 50BendamSenior
T50P009Formula 50ChadSenior
T50P010Formula 50ChenJunior
T50P011Formula 50SengJunior
T50P012Formula 50KongJunior
T50P013Formula 50ChenJunior
T50P014Formula 50DamienJunior
T51P015Formula 51****Junior
T51P016Formula 51EfqaJunior
T51P017Formula 51RidzJunior
T51P018Formula 51GregJunior
T51P019Formula 51GrannyJunior
T51P020Formula 51IkeaJunior
T51P021Formula 51KingJunior
T51P022Formula 51QueenJunior
T51P023Formula 51RhinoJunior
T51P024Formula 51KokoJunior
T51P025Formula 51MakiJunior
T51P026Formula 51AoiJunior
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You must log in or register to reply here.

Forum statistics

Threads
1,224,737
Messages
6,180,670
Members
452,993
Latest member
FDARYABEE

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top