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

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