View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DaveO DaveO is offline
external usenet poster
 
Posts: 94
Default Designing a spreadsheet

Go into the cell's formats (can be done in 1 large group) and then go to the
protection tab.

Make sure the cells you want to be not altered are lcoked.

Then protect your worksheet from the Tools---Protection---Protect Sheet
topion.

HTH.

"Sally Mae" wrote:

I have a spreadsheet that I want to design in a certain way e.g. with colors
and fonts. I then want these changes "frozen" to the spreadsheet so that a
user cannot change these settings. Does anyone have an idea? Please help me?