Reset Default Colours In Windows 7?

Apr 24, 2012

We have only just converted to Windows 7 from Windows 2000 and can't find the option to reset default colours. In Windows 2000 it is in: tools/options/colour.

View 2 Replies


Default View Of VB Windows

Feb 18, 2010

Having trouble setting VB windows views back to deafult ...

View 14 Replies View Related

Reset Scroll Bar To Default

Oct 2, 2007

I have a form that deals with 9 different parameters of human physiology. I can manually set each parameter to display "Normal" values, but then I use a Scroll Bar for each parameter that allows me to change from higher values to lower values and back again.

Is there coding for a Reset Button that will allow me to reset each Scroll Bar to "Normal' default values?

View 9 Replies View Related

Launching Excel In Separate Windows As Default?

Aug 16, 2012

Each time I click on an Excel file the worksheet will open up within an existing Excel worksheet that I have open. This is frustrating when you are working with two monitors or screens (laptop screen and additional monitor) and want to view each worksheet separately in separate screens. What I end up doing, which is not efficient, is I'll open the second worksheet which will open up in an existing worksheet that I have open and then I'll close it, and then launch a separate Excel worksheet and pull open the recent file and I'll have two open worksheets (not within same Excel worksheet I already have open). This allows me to grab and pull one worksheet in a separate screen and leave the other as I need both open on two monitors.

Question: is there a way to default Excel when opening or double clicking an Excel file to automatically open in a separate instance of Excel and not in an existing open worksheet?

View 2 Replies View Related

Reset Userform Controls To Default

Dec 18, 2006

I am planning to set a RESET(command button) button in my userform,so that user can delete or change all the input data which she/he have been entered,back to the default one that I predefined.

View 5 Replies View Related

Reset Default Printer Settings In Vba

Jun 14, 2007

We have printer mailboxes setup for all of the employees and sometimes the print settings get saved in the excel files. This means that when another employee uses the file their prints get sent to the wrong mailbox. We have hundreds of files like this and it causes all kinds of problems with prints going to wrong mailboxes!
Obviously their default print settings are all set to their own mailboxes.

Is there some way, using vba, to get an excel file to go back to using the user's default printer settings instead of the ones saved in it's file? (or get it to remove the printer settings saved in it's file). That way I could just make an application level open event to fix the problem! Either that or some way, in vba, of changing a user's storage box number for a specific printer.

View 2 Replies View Related

Open Windows File Chooser At Default Location

Feb 14, 2012

Is there any way of making the default directory location for application.getopenfilename work properly with shared locations?

Presently I use ChDrive then Chdir but I cant use ChDrive if workbook is opened from a link in email for example. Please see below

I have a VBA routine that asks the user to load an existing file on startup.

I want the window for the file selection to open at the same folder every time. (the folder is on a shared drive)

The workbook to run the code will always be located on this same share at a fixed location.

My present code builds the path to the desired opening folder by collecting the drive letter from the current working directory (which has to be done as everybody maps there shares to different letters here, its not guaranteed to be the same! )

then i ChDrive to this letter.

Then I ChDir to letter plus myKnowndirPath

This works fine, the window always opens at my required folder. But only as long as the user has navigated to the folder containing the spreadsheet and then ran it from there. Because that way a drive letter is available.

However i found that if i sent a link to the workbook or its home folder. And the user opens the link or a windows explorer from that link and then runs file from there.

Then it stops working beacause there is no local drive letter in the working directory path. i.e. working directory shows as

'network \shareddrive
ootafolderanother arget

instead of something like
J:afolderanother arget

View 2 Replies View Related

How To Create And Add Password To Default Windows Zip File Using VBA Macro

Mar 17, 2013

how to create and add password to a default windows zip file using vba excel macro.

View 2 Replies View Related

Reset Colors Back To Default Color Scheme

Mar 12, 2008

I'm not sure what I have done but one of my workbooks colour scheme has changed. When viewing the workbook cells are now grey and the lies are a lighter grey. When printing though it prnts as it would normally ie a white backgorund. It looks like the viewing colours have been reversed and I can not find out how to revery back to normal.

View 3 Replies View Related

Excel 2010 :: How To Reset Workbook Default Format To General

Jan 25, 2011

Using Excel 2010 - I have a large workbook with multiple worksheets - been using it succesfully every day for a long time. All of a sudden every empty cell, and any cell not specifically formated in every worksheet has a default cell format of Time. Any new workbook created is OK.. defaults to 'General' - But, if I add a new blank worksheet to this particular workbook it defaults to 'Time' format. How did the default cell format for this workbook become set to 'Time' from 'General' and how do i fix it?

View 2 Replies View Related

Top 3 With Dark Colours - Remaining 2 With Light Colours In Conditional Formatting?

May 6, 2014

I'm sure this will be an easy query.

These are marks scored by 5 people in 10 exams

Name of the student

A1 to K6

In each row top 5 MARKS should be filled with BLUE,VIOLET,YELLOW,RED AND PINK

If its not possible. Top 3 with dark colour, remaining 2 with light colour using conditional formatting

View 1 Replies View Related

Metallic Background Colours / Other Colours

Oct 29, 2007

The idea came about after wanting to show a 'gold' 'silver' and 'bronze' background colour, but having to plump for yellow, grey and orange looked a little crap :f

If not, can a workaround be created by using code and a picture or 2?

View 9 Replies View Related

Counting Colours

Nov 9, 2006

My Request is in Two Parts.
Firstly, I would like to be able to List ALL the Colours Numbers in One Column & the Corresponding Colours Next to them Please in a Sheet Named "Summary" & Starting in Cell T3.

Secondly, I would like to Count How Many Cells in a Range on a Sheet Named "Network Points" and in Cells F4:Q179 has a Particular Colour Please. I would like the Totals to go on the Sheet Named "Summary" Starting in Cell W3.

View 9 Replies View Related

Get A Total But Only Using Colours

Apr 8, 2009

Is there anyway to get a total but only using colours?

eg, I want to colour blocks in blue and at the end of the row, I want it to count how many were blue.

View 9 Replies View Related

Sum Of Cells According To Their Colours!

Jun 27, 2006

I want to know sum of cells according to their colours,but without using "macro".
to clarify my request, take a look in this attached file.

View 6 Replies View Related

Values Into Colours (IF Formula)

Oct 7, 2009

I am evaluating a wellness programme at work. One of the things we measure is BMI (Body Mass Index).

What Im wanting to do is to categorise the BMI values into flags. For example someone who has a BMI of >35 could be red, someone with a BMI of 25-35 could be yellow, and <24 green.

What im wondering if excel can do is;

If I write the BMI value one cell can I get excel to automatically fill in another cell in either the colour or the name of the colour?

View 9 Replies View Related

Changing The Colours Of A Userform

Oct 8, 2008

I would like to change the colour of a userform both the background colour and the font colour. However, in the colour property box I am met with &H00C0C0C0& (which is Grey). I can select some other colours but not the one I would like to use.

I have tried inserting RGB(194,214,154) however I get the error 'Invaild proprty value'

View 3 Replies View Related

Changing Colours On Conditions

Mar 5, 2008

i am creating a spreadsheet to account for work being done on a team. At the moment the sheet adds up the average time that the whole team is taking to do a task,and it also adds up the time each person is taking.

so for instance: KL take 100 minutes to do the task. but the average time across the team is 90 minutes per task.
i have my list of staff with their times in column E. so what i want is if their time is higher than the average then the box turns red, if it is lower then green etc.
(the average figure is got by summing everyones totals in box B22.

View 9 Replies View Related

Picking Out Cells With Colours

May 18, 2009

I have a column where some cells are coloured yellow. In another column, I'd like to mark out these cells, e.g. if the cell next to it was yellow, I would like to to display 'Y'.

View 9 Replies View Related

Manipulation Cell Colours

Jun 22, 2009

Is it possible to create a formula that looks at a cell (say A20) and if TRUE changes the colour of A22 to green if false to red?

View 9 Replies View Related

Looping And Font Colours

Jul 9, 2009

I currently have the following macro which checks the cell contents and replaces a random number in a sheet (say Sheet1) with a name in another sheet (called 'Pool') making sure the names' font colour is the same. So for example in sheet1, cell A1 contains the number 1 - the macro looks at cell A1 in the 'Pool' sheet (in which cells A1 to A30 always contain the numbers 1 to 30) and replaces the number 1 in Sheet1 with the name in cell D1 including the same font colour. Basically, it is replacing numbers in one sheet with names on another.

As follows: ...

View 9 Replies View Related

How Many Colours Are There In 2003 And 2007?

Jan 3, 2010

For a particular requirement I want to utilise the colours.
ANd therefore I need to know, how many colours are present in the Colour Palette in both 2003 and 2007 and which colours would be same if I make the File in 2007?

Are there 60 colours in 2003?

View 9 Replies View Related

Color The Cells With Different Colours

Jan 21, 2010

I have so many rows with numbers, when I do the matching I color them with different colors. I am looking for a color code adjacent cell with auto update.

View 9 Replies View Related

Use Cell Colours In Graph

Feb 21, 2007

Attached is a table detailing top 20 Incidents and Requests. Requests are highlighted in Yellow and Incidents are in Green. Associated with this table is a graph. What I like to do is if the bar on the graph represents a Request I want the colour to be yellow and if the bar represents an Incident I want it to be green. At the moment I can only choice one colour or a different colour for each bar.

View 4 Replies View Related

Vba Auto-update Colours

May 1, 2007

I am in charge of a report spreadsheet which gets updated by my users multiple times a day. The spreadsheet is called the R-A-G report (red, amber, green). One of the columns has colours which are updated manually in accordance to the ammount of stock we have in the database (oracle column) and in our warehouse (utl column).

Right now the users update these colours manually, using a key at the bottom of the spreadsheet. My dream is to have these colours auto-updating when a macro is run.

I spent a little time and wrote a very basic macro, but there are a few problems with it. For one i do not think that the macro fills out of the possible variables; therefor it has around 50% accuracy.

I have uploaded the file and would really appreciate if i could get some feedback on how i could write this correctly, maybe some usefull websites specifically directed at elseif (if that is the correct code for me to use).

View 9 Replies View Related

Conditional Formatting Highlight In Different Colours

Nov 3, 2008

In a range, say A1:D5, I need to format cells as follows:

1) If cell contains only "H" or "HV": highlight red
2) If cell contains only a number: highlight blue
3) If cell contains a number with the letter "F" ("1 F" or "5.5 F"): highlight pink

View 2 Replies View Related

Formula For Changing Date Different Colours

Nov 10, 2008

i need a formula that does the following:

if the date is two months under the date it needs to be checked it goes yellow
if its over two months before it needs checked it goes green
if its passed the date it needs to be checked by it turns red

View 5 Replies View Related

Keep Cell Colours Regardless Of Sort Function

Jan 8, 2010

I have a vertical list where every other cell is coloured grey. The values contained in the list are regularly sorted into alphabetical order with new values being added and other being removed.

Is there a way to keep the cells alternate grey & white after I have sorted them? Currently, when I sort, if a cell is coloured grey and is moved down one cell the colour is moved and not just the values.

View 2 Replies View Related

Changing Colours Of Certain Words In String?

Feb 22, 2013

I have a conditional formula which populates a string depending on the value selected by user.

E.G of formula is:- =IF($B$1=0,"CONTACT PERSON - OPTIONAL",IF($B$1=5,"CONTACT PERSON - MANDATORY",""))

Where the result is "CONTACT PERSON - MANDATORY" then I want the word MANDATORY (not the whole string) to be displayed in RED.

View 3 Replies View Related

Changing Colours Of Part Of String

Feb 22, 2013

I have a conditional formula which gives a value based on what the User specifies.

Example of formula is:


If the result of the string is " CONTACT PERSON (FINANCE ONLY) - MANDATORY " then
- word MANDATORY (not the whole string) should be in RED
- words (FINANCE ONLY) should be in BLUE
- remaining string should be left in BLANK

Not intending to use VBA. Is this possible?

View 10 Replies View Related

Copyrights 2005-15, All rights reserved