default worksheet background color

Kade

Active Member
Joined
Jul 20, 2002
Messages
258
Hi,

I expect this is an egg on face question, and I have searched and the board for a solution.

How can I alter the default background colour of a worksheet so that when I open a new file the background (all cells) will be, say, very light grey?

I don't want to select all and then force the colour.

I was hoping it would be a selectable option but I can't find it.

If not is there code that can do it.

thanks kade
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
Some solutions,

the first one is more drastic. You can change the "Window background" color in the Display settings.

two, you can create a new template, called Book.xlt, with the green background.

three... mmhmm, maybe, a macro in the Personal.xls workbook, or in an addin that loads on startup that has application events enabled, checking for every new workbook.
 

Kade

Active Member
Joined
Jul 20, 2002
Messages
258
thanks Juan,


The first option, I assume you mean the complete windows default not just excel?. A bit to drastic for me, and as this file is distributed to others it wouldn't work on their computers

The second, I assume you mean select all cells, apply the colour and save as a xlt (tried this but causes probs in the default pring range)

I was hoping it could be achieved so that when I selected "no fill" on cell colour it would show the selected shade.

I do not have the skills to embark on your third option

Perhaps my needs are a bit fussy ~~

ta kade
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
If you're OK with an .xlt solution, how about this:

1) Open MS paint or equivalent
2) Create a picture with just the colour you want (simple with the 'fill with colour' option
3) save picture.
4) In excel, open new file
5) Format | sheet | Background - select your file
6) Save as .xlt

Paddy
 

Kade

Active Member
Joined
Jul 20, 2002
Messages
258
Paddy you are a genius!
This does exactly what I want

Follow up Q.
no need to reply if no answer, but I was curious if it was possible for later inserted sheets to automatically have this background formatting?

No big deal as I can easily get round it by move /copy sheet when I need extra sheets. Just curious if the insert sheet can be pre formatted.

I understand that code could do the job somehow but this would not be warranted.

anyhow thanks again Paddy

kade
 

RichardS

Well-known Member
Joined
Feb 16, 2002
Messages
761
I think there are Sheet templates also?? SO when the user inserst another sheet the option is there to insert your template. Look in Help under "Sheet Template".

Richard
 

Forum statistics

Threads
1,144,360
Messages
5,723,902
Members
422,525
Latest member
dsenff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top