View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Detect Group mode

Hi Tim:

How about the following?:

If ActiveWindow.SelectedSheets.Count 1 Then '...

Regards,

Vasant.

"Tim Aurthur" wrote in message
...
Is there a standard way to detect whether more than one sheet is selected

in
a workbook?

There doesn't seem to be a Worksheets(x).Selected property, which would
allow me to flip through the workbook and see whether a group of sheets is
selected rather than a single one.

What I'm doing now is this:

If Right(Application.Caption, 7) = "[Group]" Then

which is kludgy and may be dangerous.

There must be a better way to do this, but I can't seem to find it.

-Tim Aurthur