Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have not been able to find anything that would allow me
to prevent Excel spreadsheet users from selecting multiple worksheets in a given workbook. Problem I'm trying to solve is this, though it can be summed up differently, Users use a workbook that has multiple worksheets in it. As is commonly known to Excel users, if multiple worksheets are selected, then data is changed on any of those multiple sheets the same data is applied to all selected worksheets. I want to be able to prevent the selection of multiple worksheets in the first place. I have figured out that if multiple sheets are already highlighted/selected, then any other non-active worksheet is selected, to make that new active worksheet the only selected sheet. However, I have not figured out how to prevent a user from first selecting a worksheet then say holding the shift key selecting a worksheet several tabs over, and then editing data on the active sheet which would then change the data of all the selected sheets. If anyone knows how to prevent the selection of multiple worksheets from the get go, I wouldn't need so much user error correction/prevention. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiple selection | Excel Discussion (Misc queries) | |||
multiple selection copy & paste across multi-worksheets | Excel Discussion (Misc queries) | |||
Hiding worksheets based on user selection | Excel Worksheet Functions | |||
Excel should have unhide all worksheets selection or button. | Excel Worksheet Functions | |||
Disabling protected cell selection | Excel Worksheet Functions |