Use this line of code to determine how many sheets are currently selected...

ActiveWindow.SelectedSheets.Count
--
HTH...

Jim Thomlinson


"Steph" wrote:

Is there a way to check for and/or display an error message in VBA if the
active sheet is grouped with another sheet?

Thanks for your help.

--
Steph