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
"volleykid77" <(E-Mail Removed)> wrote in message
news:07C998FE-3D41-4E8F-A7F9-(E-Mail Removed)...
|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



volleykid77 wrote:
>
> 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