Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection of spreadsheet
I am using Excell 2003
I have a price list that I want to add to our intranet for the Sales people to use. I protected the whole sheet to prevent any accidental changes. Because the price sheet is made up of many rows and columns, I want the users to be able to click on a row and "add a fill color" to it to help them read across the row correctly. Is there a way to allow them to do this to a protected sheet? Aurora |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection of spreadsheet
Hi,
When applying the protection check the option 'Allow user to format cells' Mike "Aurora" wrote: I am using Excell 2003 I have a price list that I want to add to our intranet for the Sales people to use. I protected the whole sheet to prevent any accidental changes. Because the price sheet is made up of many rows and columns, I want the users to be able to click on a row and "add a fill color" to it to help them read across the row correctly. Is there a way to allow them to do this to a protected sheet? Aurora |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protection on Excel Spreadsheet | Excel Worksheet Functions | |||
how to remove protection from a spreadsheet | Excel Discussion (Misc queries) | |||
Protection from copying and pasting into a new spreadsheet | Excel Discussion (Misc queries) | |||
spreadsheet protection? | Excel Worksheet Functions | |||
Spreadsheet protection password | Excel Worksheet Functions |