Clear cell value without macro?

[Ed from AZ]

Is there any way to clear a cell value when the sheet is selected or
the workbook opened without using a macro?

Ed

 

[Pete_UK]

Click on the cell and press the <delete> key.

Is this what you mean?

Pete

 

[Ed from AZ]

Click on the cell and press the <delete> key.
Is this what you mean?

Not quite. I'm asking if there is perhaps some worksheet function or
orther method of capturing the sheet selection, workbook opening, or
other event to automatically clear a cell's contents without user
intervention and without VBA.

Ed

 

[Dave Peterson]

Nope.

There are worksheet/workbook events that could do it, but each would involve
VBA.

 

[RagDyeR]

Backward approach might be -
close without saving after data entry and/or printing.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Click on the cell and press the <delete> key.
Is this what you mean?

Not quite. I'm asking if there is perhaps some worksheet function or
orther method of capturing the sheet selection, workbook opening, or
other event to automatically clear a cell's contents without user
intervention and without VBA.

Ed

 

[Ed from AZ]

Nope.

There are worksheet/workbook events that could do it, but each would involve
VBA.

Thanks, Dave. That's what I figured, but I thought I'd ask anyway.

Ed