Disable Multi Tab Select Functionality

[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.

 

[Jim Rech]

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.

 

[Dave Peterson]

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