clearing cells upon opening or closing

**sc10** · 12-30-2009, 01:28 PM

Is there a way to clear a specific cell upon the opening or closing of the file? So for instance, I want the information in cell a1 to clear automatically upon either the opening or closing of the document, but all other cells remain unchanged (assuming that I save it before I close). Is this possible? Thanks for any help on this........

**shg** · 12-30-2009, 01:37 PM

It would require VBA, and there are some hoops you'd need to go through to force the user to enable macros in order to use the workbook.

**orbatrin** · 01-02-2010, 02:25 AM

I believe this is what your looking for. place any code within this event:

Please Login or Register  to view this content.

This code to run at open of workbook:

Please Login or Register  to view this content.

**Palmetto** · 01-02-2010, 10:23 AM

You should specify which worksheet(s) in which to clear the cell.

Please Login or Register  to view this content.

Note: the above code uses the worksheet code name (not the worksheet name, i.e. "January", or "Budget", etc.)

If there is more than one worksheet involved, you will need additional code and must provide more details.

As shg points out, all VBA code is subject to the user choosing to enable macros when the file is opened.