I've got some code in a spreadsheet that will be called when the user tries
to insert a sheet, so that any sheet inserted already has the formatting and
other hidden ranges needed inside it. Part of this process involves
unprotecting the current activesheet, making some changes, then reprotecting
it.

The activesheet object seems to be accessible programitcally when all sheets
have been selected - at least in regards to retreiving property values - but
falls over when the unprotect and protect methods are called.

The user shouldn't really be selecting multiple sheets but they shouldn't be
seeing such errors either. Is there any way of checking to see if multiple
sheets have been selected from within VBA code within the spreadsheet?
Activesheet doean't seem to provide me with any useful information and I
would prefer to avoid calling any methods to check to see if any errors are
returned.

I'm currently using Excel 2003, but the solution would have to work in Excel
97 too.

---
Patrick Seurre