T
Tim Aurthur
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
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