Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protect in Excel 2000
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protect in Excel 2000
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 "Rodrigo" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protect in Excel 2000
In Excel 2002 and later, it should be an option under Protection, Protect
Sheet. -- Regards, Tom Ogilvy "Rodrigo" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protect in Excel 2000
That is the point.. i only have Excel 2000
Regards Rodrigo "Chip Pearson" wrote: 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 "Rodrigo" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protect in Excel 2000
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). -- Regards, Tom Ogilvy "Rodrigo" wrote in message ... That is the point.. i only have Excel 2000 Regards Rodrigo "Chip Pearson" wrote: 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 "Rodrigo" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I protect a worksheet yet allow editing in Excel 2000 | Excel Discussion (Misc queries) | |||
Protect Excel 2000 Objects | Excel Programming | |||
How can I protect cells in Excel 2000? | Excel Worksheet Functions | |||
IN EXCEL 2000, HOW DO I PROTECT MULTIPLE WORKSHEET | Excel Worksheet Functions | |||
.Net and Excel 2000 Protect | Excel Programming |