Bo

Yes that works - many thank

Roge

----- Bob Phillips wrote: ----

Rog

Tr

activewindow.selectedsheets.Count

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

"R-N" wrote in messag
..
How can I detect if the user is in Group Mode when a macro starts
I have a macro that needs to warn the user if they are in group mod
before it runs its main actions. I can't find a mechanism like..
If Selection.Sheets.Count 1 or For Each aSheet In Wb.Sheets, I
aSheet.Selected = True etc. etc
I have a fix that writes an unlikely entry and then looks through th
sheets to see if the unlikely entry has appeared on other sheets but ther
must be a better way than this
Any ideas much appreciated
Ro