way to delete the input area on several Excel spreadsheets
 

Is there a way to delete the data input area of several worksheets at the
same time using a macro maybe?

way to delete the input area on several Excel spreadsheets
 

You can group the sheets by CTRL + click on sheet tabs.

On active sheet select the range to delete and hit delete button.

All grouped sheets will have that range deleted.

You may want to select all cells on the active sheet and F5SpecialConstants

This will leave formulas intact.

DO NOT FORGET to ungroup the sheets when done this operation.


Gord Dibben MS Excel MVP

On Thu, 2 Aug 2007 11:44:03 -0700, MarcelMarceau
wrote:

Is there a way to delete the data input area of several worksheets at the
same time using a macro maybe?

way to delete the input area on several Excel spreadsheets
 

1) Click on the tab of one of the sheets that you want to delete data on.
2) Select the range that you want to delete.
3) Hold down the Ctrl key and then click on other sheets that contain the
information that you want to delete.
4) Hit the Delete key.

--
RyGuy


"MarcelMarceau" wrote:

Is there a way to delete the data input area of several worksheets at the
same time using a macro maybe?