| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Lock worksheet, based on dropdown selection prior worksheet
Hi,
I am creating a workbook, where I have several worksheet that are labeled with the same first 7 characters "ab123 -". The user selects one of these sheets from a dropdown in the first worksheet. I provide a conditionally formatted hyperlink within worksheet A, based on their selection, but for quality control want an additional step that either locks an incorrect selection or presenting a msgbox to re-direct. Can this be done? Thanks Michele |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dropdown lists and populating new table based on the selection | Excel Discussion (Misc queries) | |||
| How to limit columns that display based on selection of a dropdown value | Excel Worksheet Functions | |||
| How do you lock a cell after making a selection from a dropdown b | Excel Worksheet Functions | |||
| Move entire row to another worksheet based on drop list selection | Excel Worksheet Functions | |||
| import worksheet based on a selection | Excel Discussion (Misc queries) | |||
Threaded Mode
