Unactivating

  • Thread starter Thread starter Terry von Gease
  • Start date Start date
T

Terry von Gease

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 said:
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?
Click to expand...

Regards
BrianB
=======================================
 
To use cells as buttons while protecting their contents without dealing with
any of excel's inelegant and annoying error messages about changing the
contents of locked cells. In other words to have a cell that has it's
contents locked silently.

Buttons themselves are rather clumsy bulky things, okay for a couple or
three but more than that rapidly becomes a pain in the ass for alignment and
sizing as well as being visually repulsive.

While I could easily select some editable cell upon selection of the cell
acting as button there is a bit of a problem with this on a sheet that has
no unprotected cells, no place to go.

Another method, probably the one I will end up having to use, would be to
set the format of the button cell to some constant value, for example set
the format to """sort"";""sort"";""sort"";""sort""" then not only trap
selection events for this cell to invoke whatever it is I want to invoke but
also trap changes to the cell and simply clear it out every time someone
attempts to enter anything in it. There's problems with this as well.

--
Terry

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