Does anyone know a way to have a sheet with no selection and no cell
activated? A simple function, not a side effect of locking, protecting,
baying at the moon, or any of that. Merely be able to say something like
'Sheets("my_sheet").Deactivate' or whatever and end up with no ActiveCell
and no Selection?

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

Hi Terry:

No.

Regards,

Vasant.

"Terry von Gease" wrote in message
...
Does anyone know a way to have a sheet with no selection and no cell
activated? A simple function, not a side effect of locking, protecting,
baying at the moon, or any of that. Merely be able to say something like
'Sheets("my_sheet").Deactivate' or whatever and end up with no ActiveCell
and no Selection?

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

In VBA no problem. Just .Activate another sheet.

If this isn't exactly what you want (ie. there may be cells selected
in the sheet to come back to) Range("A1").Select will get you back to
the minimum possible.

NB. ActiveCell is a child of the Application Object.

"Terry von Gease" wrote in message ...
Does anyone know a way to have a sheet with no selection and no cell
activated? A simple function, not a side effect of locking, protecting,
baying at the moon, or any of that. Merely be able to say something like
'Sheets("my_sheet").Deactivate' or whatever and end up with no ActiveCell
and no Selection?

Regards
BrianB
=======================================