Excel 2007 :: Change Colour Of Tabs To Match Other Tabs In Workbook

Sep 22, 2012

I have been trying to get Excel (2007) to change the colour of tabs to match other tabs in the workbook

Using this code I get the colour code of the current tab

x = ActiveSheet.Tab.ColorIndex

But when I use this value in a procedure like this:

ActiveSheet.Tab.ColorIndex = x

The tab is a different colour!

View 3 Replies


Listbox Linked To Workbook Tabs (2007)

Oct 17, 2008

I hope I can explain what I am trying to accomplish properly. Many years ago (5+), I had this exact workbook setup, but am having a lot of difficulty remembering VB & Excel and making this again from scratch.

I am looking to create an Excel Workbook. The workbook will contain numerous tabs, each tab will essentially be a template, and contain basic formulas.

On tab 1(Sheet1), I would like to have a listbox. The individual items in the listbox, should have the same name of, and be linked to all tabs in the workbook.

There will also be three buttons.

Button1 - Generates the names in the listbox based on existing tabs within the workbook
Button2 - Opens a new workbook, and copies over the selected tabs (AKA - creates a working copy of the workbook)
Button3 - Clears the selection and resets the listbox.

The number of tabs, and contents of tabs, within the workbook will be changing. So the listbox should know to look for all tabs, be it 5, or 50.

The end result would allow someone, who knows nothing of Excel, to open this workbook, as a read-only file. Generate a list of available tabs, select the tabs they need, generate a new workbook containing these tabs, that they can then edit to suit their needs.

In my line of work (and I am sure everyones) there is a huge problem with consistancy. This leads to a snowball effect of problems carrying over, and being copied from one project to the next. As I mentioned earler, I once already had this workbook setup, and it solved all our consistancy problems. I am hoping to do the same.

View 8 Replies View Related

Excel 2007 And Tabs

Jan 22, 2008

I have just started using Excel 2007 after many years with 2003 and I must say that the new one is totally amazing except for one thing and Im sure there is an easy answer to this although the HELP was NO HELP

One the sheet I am working on I hide the sheet tabs through 2003 and now I see there is no options to unhide them. How do I do this.

View 6 Replies View Related

Excel 2007 :: Hiding Tabs With Hyperlink?

May 17, 2010

I am using excel 2007. My workbook contains a tab with several buttons with hyperlinks to corresponding other tabs in the workbook. The hyperlink works fine when the tabs are visible, but do not work when I hide the tabs.

Is there a way use hyperlinks on tabs that are hidden?

View 8 Replies View Related

Excel 2007: Tabs Not Showing On Ribbin

Sep 8, 2009

I've just started using Excel 2007, and despite manually activating the add-ins I use, the add-ins tab is not showing on the toolbar. Also, I can't find the format tab either.

View 6 Replies View Related

Excel 2007 :: Sorting Tabs In Alphabetical Order

Feb 7, 2011

I have excel 2007, I have a spread sheet with approx 80 worksheets. The document grew over the year of 2010 and is not in alphabetical order. I am starting this new year wanting to have the tabs in alphabetical order. I looked in the DATA sort option...but looks like its is worksheet specific. How to make the tabs sort in alphabetical order...

View 5 Replies View Related

Excel 2007 :: Compare Data On Two Tabs And Populate Differences On New Tab?

Jan 24, 2014

What I'm tying to achive is to compare data on two worksheets called "Old" and "New" and to populate the difference on another worksheet called "Diff" see attached file where I have manually added the differences onto the "Diff" tab.

Is it possible via VBA or Vlookups to achive this

N.B. Excel version 2007

View 3 Replies View Related

Excel 2007 :: Sheet Tabs At The Bottom Of Screen No Longer There

Apr 26, 2012

I am using Excel 2007. When I pulled up a workbook today with 3 sheets in it, all that comes up is the first sheet and the sheet tabs at the bottom of the screen are no longer there. I must have accidentlly pushed some button, but I can't get to the other sheets. I really need the information on the other sheets. How do I restore the view that shows the sheet numbers at the bottom?

View 2 Replies View Related

Create Formula Using 2 Different Tabs Within Excel Workbook

Apr 24, 2014

I need to create a formula using 2 different tabs within an excel workbook. I need to search column A on the first tab and column A on the second tab and if they match I need to compare column F on the first tab to column F on the second tab. (This column contains my staff names but the problem I am running into is on the first tab their names are listed first name last name and on the second tab they are listed last name, first name). If column A and F match I need to search column H on the first tab to column H on the second tab. If all columns match up to this point I need to take the data in column Q on the second tab and in put it into column K on the first tab. Is this even possible?

View 2 Replies View Related

Link And Change Source For Multiple Tabs From Excel To PowerPoint

Jan 18, 2012

I have to prepare a monthly presentation for my company. I have all financial data in multiple tabs in excel that have been linked to many powerpoint slides.

The problem is, I update the same excel sheet every month and save it with a different name. How can I change the source in powerpoint to select and update all the slides with all the corresponding tabs.

At present, I use Edit link (ALT+E+K) > Select each slide on the powerpoint> Change source to new excelfile. When I select all the sheets, the "change source" greys out. Hence I have to do it individually.

View 2 Replies View Related

Excel 2007 :: Change Colour Settings?

Oct 9, 2011

Is there any way to change the settings in excel 2007, to give me the original color palate from 2003? I want to use the old colors because I don't like the new ones.

View 2 Replies View Related

Use The Names Of The Tabs In The Summary Page And Create It Into A Formula To Lookup Fixed Cells Within The Various Tabs

Oct 12, 2009

I have a summary page that includes the titles for each tab within the excel 2003 workbook. I want to use the names of the tabs in the summary page and create it into a formula to lookup fixed cells within the various tabs. Sorry for not uploading an excel doc but I was at work earlier and the thread did not load for some reason, so I am reposting it.

View 3 Replies View Related

Excel 2007 :: Current Time Causing Cell To Change Colour

Jun 4, 2014

I am creating a spreadsheet in Microsoft Excel 2007 which holds information about the airline Emirates which I have created using information from the internet. I am currently creating a sheet which has all their flights in and holds information about the departure time and arrival time of the flight and the type of aircraft ect. I am wondering if there is anyway in being able to have the cell which has the flight number in to change colour (Green or Red) if the flight is in the air or not by using the departure and arrival times already set on the sheet. I am wondering if you possibly need to have a live time on the sheet so that it can work with that .....

View 1 Replies View Related

Excel 2007 :: Clicking Cells To Change Colour Format And Mirroring

Feb 24, 2012

(Using Excel 2007)

What would be the quickest and most efficient way of doing the following:


Sheet 1: clicking once, twice, three times in the following cells to change the fill to Red, Yellow, Green respectively (in Row 22, COLUMNS E H K N Q T W Z AD AG) and mirrorring this format/fill on:

Sheet 2: , mirror the selected fill on sheet1 in E22, H22 , K22 in in E3:N3 respectively example E22 (sheet1) is mirrored now in E3 (sheet 2); H22 (sheet 1) is mirrored in F3 (sheet2) etc etc.

I have 35 tabs formatted in the same way - each tab, as with Sheet 1 is linked to a different row on sheet 2 in the same range as is sheet 1 and would need to replicate the mirorring on Sheet 1 to each of the other 34 tabs.

View 9 Replies View Related

Sheet Tabs In 2007

Oct 7, 2007

Have designed a spreadsheet in 2003 at work and got home to work on in it using my machine which has 2007 loaded.

Have hidden the sheet tabs on the 2003 sheet and can not find the option in 2007 to make them visible again.

I realise I can ctrl-pgup and pgdn but I got a fair bit of movement from sheet to sheet to do and that wont be practical.

View 6 Replies View Related

If Match Times By Columns In Other Tabs?

Feb 11, 2014

What I need to do is work out the cost of call 1, to work out the call cost you will times the duration by the cost of the call on the charging codes tab. So if E2 = uk Mobile 02 (fm1) then search for a match in charging codes tab column B then get the cost from column C and times that by the duration on CDRS test tab column D

the cost amount needs to be in column I

a different explanation below..

if CELL e2 matches a column in charging codes tab column B then get the amount of cost from charging codes tab column C and times it by cdrs tab CELL d2 and return the result in CELL I2

View 9 Replies View Related

Workbook With Several Tabs

Dec 9, 2005

I have a workbook with several tabs. The top tab is the main spreadsheet
were I enter all my gathered data. The other tabs are the same spreadsheet,
the same data, but broken out by specific building.

Right now, I enter the data (alpha and numeric) into the main spreadsheet,
then manually copy/paste it to the respective sub-level spreadsheet.

I can specify the "IF" part of the line item that would identify which sheet
to copy it to, but is it possible to have a "THEN copy and paste [these
cells]" to the other spreadsheets?

View 14 Replies View Related

Excel 2007 :: Get Cell To Refer To Date That It Contains And Change Cell Colour Based On That?

Dec 19, 2012

I work for a UK charity and have a list of funders in an Excel 2007 spreadsheet.

One of the columns refers to the date on which a new application for funding can be made to that particular funder.

In many cases new applications for funding can't be made for 1 or more years since the last application - sometimes as many as 5 years later. How to get a cell to refer to the date that it contains.

For example, say I have in cell A1 "The Acme Funding Organisation" and in cell B1 (i.e. the "Reapply when?" column) a date of 01/04/2013 (British date format, i.e. 1 April 2013) then what I want Excel to do is to look at the date in cell B1 and if that date has been reached to highlight the cell red. That way I'll know that the reapply date has been reached & that a new application can be made.

View 2 Replies View Related

Rename All Tabs In Workbook

Jan 21, 2010

I have a workbook that pulls in data from other sources and contains 15 linked sheets. The data changes when different criteria is selected in the first sheet. The first 2 sheets are summary sheets and the tabs are named correctly.

I would like to be able to rename the remaining 13 tabs using labels found in the cells in the first sheet. These tabs should update or change when the first sheet is manually recalculated (F9).

I have used ActiveSheet.Name=Range("A1") but it doesn't apply in this case. Is there a macro that could run with something like Sheet1.Name=Range("A1"), Sheet2.Name=Range("A2"), Sheet3.Name=Range("A3"), etc.... or maybe something in each sheet that would change the name of the tab to a specific name off sheet 1 when the whole workbook is recalculated?

View 10 Replies View Related

How To Print All Tabs In A Workbook

Jan 4, 2012

Just wondering if there's a "codeless" way to print en entire workbook (i.e. all tabs) without moving from tab to tab and hitting print?

View 1 Replies View Related

Add Multi-Tabs To Workbook?

Jan 12, 2012

I have to prepare files of over 100 tabs in each. I have a list of numbers on a spreadsheet that must be entered on each tab. Am I making myself clear because I tried to do it manually and it's no joke?

View 1 Replies View Related

Sort All Tabs In Workbook By Name?

Feb 19, 2013

Is there a way to Sort all the Tabs in a Workbook by the Tab name?

View 1 Replies View Related

Copy Certain Tabs To New Workbook?

Jan 10, 2014

I have a program that takes a templete, copies it, fills in some information and then renames the tab based on text in a cell on that sheet. The code loops so I end up with about ten tabs that are created from the Template.

I want to move these newly created tabs to a new Workbook.

is there a way (code) that will move all the tabs except ones delineated in the code - like the tab named "Template"?

View 1 Replies View Related

Arranging The Workbook Tabs

Mar 7, 2008

Is there any way to arrange the tab easily instead of move back and forth and drag? I have a work book with 50 tabs and if I like to arrange it, I have to move the cursor pointer zillions time and than find and drag the right tab at the right place. Is there any easir way? Like you do in power point?

View 6 Replies View Related

Workbook Tabs Seperated?

Oct 21, 2008

I made a workbook with several linking tabs and then moved the tabs to various folders. Why can I view the updated info on my cpu but others can not?

View 9 Replies View Related

Auto-naming Tabs In A Workbook

Jan 11, 2008

I have a workbook with a list of names of up to 15 people in each of 5 rows. Each row then populates a row in a separate workbook with those names. Each person is identified by a number and each person then has their own worksheet in that workbook.

Is it possible in some way to auto-name the tab for each worksheet from the number in the name cell?

View 7 Replies View Related

Extract Two Coulms From A Workbook With 31 Tabs

Dec 31, 2008

I need to extract two coulms (AQ,AR) from a workbook with 31 tabs, I want colated the same colums from each one and copy into a new workbook. I have been searching for hours but have failed.

View 4 Replies View Related

HLookup To Read Workbook That Has Several Tabs

Jan 18, 2012

I have created a Hlookup to read a workbook that has several tabs. How do I write the formula to read every tab. So if my tabs are labelled like this... FY 2012, FY 2012-2, FY 2012-3 - each spreadsheet is formatted the same, same number of rows and columns but I need the formula to look on every sheet and then bring back the information.

View 8 Replies View Related

How To Insert Multiple Tabs In The Workbook

Aug 11, 2013

how to insert multiple tabs in the workbook?

i try this


Option Explicit
Sub Add_Multiple_Tabs()
Dim Tabs As Variant
Dim I As Byte


View 7 Replies View Related

Lookup Formula- Workbook With 5 Or More Tabs

Jan 31, 2007

I have a workbook with 5 or more tabs. One of the tabs is a CONSOLIDATION of all the tabs put together. I have columns on the consolidation tab with the names of the individual tabs. To the left of these columns is a list of general ledger numbers with their respective names. For example:

East West NE South
6103256 –sales
6540000 -salary

I want a excel to look at the individual tabs, for this specific gl number and name and, if applicable, return a value. What formula would do this?

My columns are not showing up correctly. East,West etc are the columns. 6103256 - are the rows

View 9 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved