Clear cell value without macro?

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

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
 
Click on the cell and press the <delete> key.
Is this what you mean?
Click to expand...

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
 
Nope.

There are worksheet/workbook events that could do it, but each would involve
VBA.
 
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!
=====================================================

Ed from AZ said:
Click on the cell and press the <delete> key.
Is this what you mean?
Click to expand...

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
 
Nope.

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

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

Ed
 
Back
Top