ExcelBanter - Protect Format OF Worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Protect Format OF Worksheet (https://www.excelbanter.com/excel-worksheet-functions/30954-protect-format-worksheet.html)

Sherree

Protect Format OF Worksheet

How do I allow data entry on a new excel worksheet and protect the format
from being changed or deleted?

Gord Dibben

Which version of Excel are you running?

2002 and 2003 allow much more versatilty with protected sheets.

Gord Dibben Excel MVP

On Wed, 15 Jun 2005 13:34:07 -0700, "Sherree"
wrote:

How do I allow data entry on a new excel worksheet and protect the format
from being changed or deleted?

Sherree

Iam using Excel 2003.

"Gord Dibben" wrote:

Which version of Excel are you running?

2002 and 2003 allow much more versatilty with protected sheets.

Gord Dibben Excel MVP

On Wed, 15 Jun 2005 13:34:07 -0700, "Sherree"
wrote:

How do I allow data entry on a new excel worksheet and protect the format
from being changed or deleted?

All times are GMT +1. The time now is 11:47 PM.