ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Designing a spreadsheet (https://www.excelbanter.com/excel-programming/366190-designing-spreadsheet.html)

Sally Mae

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?

DaveO

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?


Hiran de Silva[_2_]

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




All times are GMT +1. The time now is 04:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com