Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Designing a spreadsheet
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Designing a spreadsheet
I use database-driven Themes often.
For spreadsheet models that get data from a database, I get (also) a 'Colour Swatch' which has several themes. So the colour scheme is database driven, and reponding to the department (or country/region for example) the user is looking at. Hiran |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Designing a spreadsheet - a brief guide | Excel Discussion (Misc queries) | |||
Designing a spreadsheet - a brief guide | New Users to Excel | |||
Designing a spreadsheet to track workflow | Excel Worksheet Functions | |||
Designing a spreadsheet to track workflow | Excel Worksheet Functions | |||
Designing a Form | Excel Discussion (Misc queries) |