Worksheet Protect in Excel 2000

[Guest]

Hi:

I need protect objects in a worksheet (ej. Pivot Tables, new lines/columns
creation, etc.), but i need than users can give format (color, number
display, etc.) into cells of the same worksheet.

It is that possible?

Thanks

Rodrigo

 

[Chip Pearson]

What version of Excel are you using? In Excel 2003, you can allow
users to format cells, but not make any changes. See the options
listed when you choose "Protect Worksheet".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

In Excel 2002 and later, it should be an option under Protection, Protect
Sheet.

 

[Guest]

That is the point.. i only have Excel 2000

Regards
Rodrigo

 

[Tom Ogilvy]

That is the point.. i only have Excel 2000

That is why it is a good idea to put all pertinent information in the body
of the post - not put critical information soley in the subject.

The only way you could protect the sheet and allow formatting is to set up
an area where the user can copy formats form pre-formatted cells and past
onto the cells to be formatted (very kludgy), or to control formatting
through your own dialogs - where you would briefly unprotect the sheet (or
use the interfaceonly property of the protect method).