Disable Multi Tab Select Functionality

  • Thread starter Thread starter volleykid77
  • Start date Start date
V

volleykid77

I am looking for a macro that I can put in the workbook module that will
disable the users ability to select multiple worksheets. I've got an active
worksheet macro that gets messed up when multiple tabs are selected.
 
If the first line in the macro is:

ActiveSheet.Select

the problem goes away.

--
Jim
|I am looking for a macro that I can put in the workbook module that will
| disable the users ability to select multiple worksheets. I've got an
active
| worksheet macro that gets messed up when multiple tabs are selected.
 
You may want to just inform the user and then stop. Let them decide if the
macro should run or the sheets remain grouped.

if activewindow.selectedsheets.count > 1 then
msgbox "Please ungroup the sheets before running this macro!
exit sub
end if
 
Back
Top