Hiding Tabs

Feb 1, 2009

hi ive made macros on excell conecting my sheets so i dont need my tabs how can i hide them and then when i need them view them again.

View 9 Replies


ADVERTISEMENT

Hiding Sheet Tabs

Oct 13, 2008

Hiding sheet tabs. can you hide tabs on excel?

View 4 Replies View Related

Hiding Tabs At The Bottom Of Sheet

Jul 23, 2014

I am using the following codes to hide the menu, formula bar and the headings. One more thing I need to do but do not know how - hiding the tabs at the bottom of the sheet. The idea is not to let users to right click and unhide other sheets.

'Hide main menu
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
'Hide headings
ActiveWindow.DisplayHeadings = False
'Hide formula bar
Application.DisplayFormulaBar = False

View 2 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 :: 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

Code:
x = ActiveSheet.Tab.ColorIndex

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

Code:
ActiveSheet.Tab.ColorIndex = x

The tab is a different colour!

View 3 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

Old Tabs Not Behaving Like New Tabs

Jun 25, 2008

I'm using Excel '03SP2 on Win 2000sp4. I believe I have a case where old tabs originally written in Excel ' 97 behave differently than new tabs in the same workbook, which is saved in 2003 format.

Specifically, the formula ="PLAN" & budyr-1 where budyr is a named range on a different tab containing 2008 . This formula yields PLAN 2007 on a new tab and #VALUE! on an old tab.

How do I get Excel to update the old tabs so that they behave as Excel 2003 tabs?

View 8 Replies View Related

Hiding Cells That Are Not Used

Mar 10, 2014

I've created a spreadsheet that will be protect for use by others. I want to hide cells that are not used so it just leaves to print area in view and gives a simple and clear look.

I know how to hide rows, columns etc but there are always further rows and columns there. I'm sure this must be simple.

View 1 Replies View Related

Userforms Not Hiding?

May 28, 2014

I have a VBA application that seems to work fine under vista but once I start working with it in Windows 7 I notice sometimes one of my userforms do not go away when asked to hide. The code is like follows:

Application.ScreenUpdating=true
Waitingform.Hide

View 1 Replies View Related

Hiding Rows...

Jul 1, 2009

I have two command buttons, and need one macro that would hide all blank rows between columns "E" and "O" and from row 9 to 42, and then another macro that would unhide all these rows again.

View 2 Replies View Related

Hiding Various Worksheets

Sep 7, 2009

I have a spreadsheet with 5 worksheets going, I've been trying to find code that will hide and unhide certain tabs depending on the answer to C21 of Worksheet 1.

If C21 = 1 then show sheet 3 but not 4 or 5
If C21 = 2 then show sheet 4 but not 3 or 5
If C21 = 3 then show sheet 5 but not 3 or 4.

View 5 Replies View Related

VBA For Hiding Rows?

Oct 29, 2012

I am building a real estate model. What I am trying to do is the following:

If I enter the number of tenants in a cell (let's say the number of tenants is 6 and the cell I enter this number in is cell J11), I would like 6 of 15 rows to be shown below (rows 46-60). Therefore, the 9 unused rows (rows 52-60) would be hidden from sight. Furthermore, if I entered the number 3 for the tenant count, excel would hide 12 rows (rows 49-60). I am sure that this is a VBA code.

View 1 Replies View Related

Form Hiding On Own

Aug 3, 2007

I am useing a user Form

On the Form which I call my main menu, theres a help button, with this code

Private Sub cmdHelp_Click()
MsgBox ("Help file not ready yet, good luck on your own, Have a Nice Day!")
End Sub
For some reason when this is click, and after the user clicks ok on the msgbox, the frmmain, which this command is on, minimizes itself

View 9 Replies View Related

Hiding UserForms

May 7, 2008

I'm trying to hide a UserForm (using myFrm.hide) once the command button on the form is clicked. I'm getting the following error:

Run-time error '402'
Must close or hide topmost modal form first.

Apparently the form isn't the 1st in the z-order. How can I see the z-order of my forms?

View 9 Replies View Related

Hiding An Autoshape

May 14, 2008

Seems like this should be pretty cut-n-dry to me...I thought I could "hide" an Autoshape (AutoShape 19) using some formula [I.E. =IF(B12="","",SUM(C37:C45)) ] but I cannot get it to work...

Basically I dont want to see the shape if there is no data D49.

View 9 Replies View Related

Hiding Checkboxes

Jul 21, 2008

I am trying to use the following
[code] ....

and modifying it to:

If Sheets("TPM").Range("al13").Value = 2 Then ActiveSheet.Shapes("Check Box 391").Visible = True

The first one works OK, but when I try to add an if / then statement, it gives me an error message.

I want to hide Check boxes 391 through to 426, using a single macro.

View 9 Replies View Related

Hiding Sheets

Jun 11, 2009

A workbook with 7 sheets in it. The first sheet contains buttons with macros that when clicked will navigate you to different sheets in the workbook based on what button you click. Here's what I want to do. When the workbook is opened, I want it open to that first sheet with the buttons, but show no other tabs for the other sheets at the bottom. And then when that button is clicked on the first sheet to go to a different page, I want that page to be the only visible tab in the workbook with the rest still hidden. Is that doable? I already have the buttons and codes and everything for the navigation part down, I just need to have the other hidden when I'm on a different sheet.

Sub Button10_click()
Worksheets("Account Type").Activate
End Sub
Sub Button11_Click()
Worksheets("Name Change").Activate
End Sub
Sub Button12_Click()
Worksheets("Address-Phone").Activate
End Sub
Sub Button13_Click()
Worksheets("Main Menu").Activate
End Sub
Sub Button15_Click()
Worksheets("Cust-Owner").Activate
End Sub
Sub Button16_Click()
Worksheets("Misc").Activate
End Sub

View 9 Replies View Related

Hiding A Row If Value Equals 0

Jun 16, 2009

how to hide a row if a value in a cell equals zero?

View 9 Replies View Related

Re-hiding Worksheets

Jan 13, 2010

I need to unhide all hidden sheets in a workbook, run some marcos on the hidden sheets, then re-hide only the sheets that were hidden. For each workbook the number of hidden sheets will vary as will the names of the sheets. Is there a way to capture the current hidden worksheet names before I unhide all worksheets and apply the captured names for re-hiding?

View 9 Replies View Related

Hiding Rows With A Cell Containing 0

Oct 25, 2006

a bit of code so that when I open a sheet (which takes data from another sheet) it hides rows which contain a zero in a certain cell?

View 10 Replies View Related

Hiding Standard Toolbar

Oct 2, 2008

I use Excel 2000.

I want to hide all toolbars when I work.

I know how to hide them during a session, but when I exit and reboot Excel, the "standard" toolbar always returns.

Is there some way to hide the "standard" toolbar permanently?

View 8 Replies View Related

Hiding Cells In Worksheet

Nov 11, 2008

I've created an Excel spreadsheet (Excel 7) to help me price sign printing jobs consistently. In my spreadsheet a few cells allow me to enter markups for materials & labour rates. These are used for calculating the retail price.

I would like to give my spreadsheet to some of my customers so they can calculate the retail price of a job themselves BUT, I would like to hide the contents of those few cells where I fix the markup. How can I achieve this?

View 3 Replies View Related

Hiding The Duplicates Values..

Sep 4, 2009

I'm trying to hide all but one duplicate value in a list; I have a report that can give multiple results for each record, but to make it cleaner to read I want to hide the duplicate values, such as customer names etc. after they have first appeared. I'm aware this may not be a very clear explanation so have attached an example spreadsheet.

The left-hand list is similar to what I would start with and the right-hand list is what I am looking to achieve. Conditional formatting will format duplicates but will obviously all to all and can't use the remove duplicates function as it will take away the unique values alongside them in the row. Preferably I'm after a solution that works in both '03 and '07 but it's not a disaster if I can only do it in '07.

View 5 Replies View Related

Hiding Cells If Empty

Jan 21, 2010

I was wondering what would be the best way to go about hiding either rows or columns based on whether a particular cell is empty or not. The reason being, I want a graph and table to only display data when present.

View 14 Replies View Related

Hiding/Unhiding Rows

Feb 8, 2010

I have a problem with hiding and unhiding columns. Is there a way wherein I can automatically hide the row(s) if the cell = "N/A" and will unhide if it's not equal to "NA". see the attachment Im using excel 2003 btw. You can see in Sheet2 to that it contains the table for the student grades. "N/A" means that they are not enrolled on that subject. While in sheet1, What I want to happen is that you will select a student name and below, it will automatically display the grades of the student on their enrolled subjects only. So, those fields with "N/A" will hide and when I update the value of N/A it will unhide.

View 5 Replies View Related

Hiding Of Sheets Through Yes Or No Selection?

Aug 19, 2013

I wanted to know if there is any function/macro/option available which can hide/show sheets based on the value selected in the particular cell.

Basically i will have a table of contents as the first sheet. Post that if 'Yes' is selected against a particular line item, the sheet for the same should appear. If 'no' is selected the sheet would remain hidden. The sheets would be linked via hyperlink to the particulars (name) for each line of the table of contents. If required i can also remove the hyperlinking of cell.

View 6 Replies View Related

Hiding Recurring Results?

Oct 31, 2013

How to hide repeated values in a column, and only display them ONCE.

See attachment. The names are in column "C" and the grey bar is not using any formula, just hardcoded. I want to apply conditional formula or something like that, to keep the names as they are, in the grey bar, but supress the names in the subsequent rows, if they are repetitions.

uaImV.png

View 1 Replies View Related

Hiding Rows Based On Value

Apr 22, 2014

The attached sheet takes information from another sheet in my work book (I am only providing the sheet I was to work with). I want all rows where the value in F is 0 to hide automatically.

Attached File : Book2.xlsx‎

View 3 Replies View Related

Hiding Multiple Worksheets With VBA

Feb 2, 2014

I have a workbook with 16 different worksheets. The first worksheet is what I'm calling a table of contents where I have created ActiveX Control Buttons that I would like to attach VBA Sub procedures to. The sub procedures I'd like to include are, as an example, hide all worksheets except worksheets 1and 2. Then I'd have another button to enact the code that says hide all worksheets except worksheets 4 and 6. I have specific names for each worksheet but hopefully that doesn't matter. I've been trying to figure out why the below doesn't seem to work.

Option Explicit
Sub Division_1and2 ()
' Open the Division 1 and 2 worksheets for data entry.
'
Sheets(Array("Division 3", "Division 4", "Division 5", "Division 6", "Division 7", _
"Division 8", "Division 9", "Division 10", "Division 11", _
"Division 12", "Division 13", "Division 14", "Division 15")). _
SelectSheets.Visible = xlSheetHidden
Sheets("Division 1").Select
End Sub

Instead of xlSheetHidden I've also used the term False to no avail.

View 3 Replies View Related

Hiding / Showing Columns ....

Jul 7, 2008

Here's what I'm trying to do -

There's a sheet called "Main" and 38 other sheets that shows the data (these 38 sheets all have the exact same structure/layout). Let's say these 38 sheets are called "country1", "country2", .... "country38".

Based on user input in cell J10 in "Main", I want to show only the relevant columns in all of the 38 country sheets. Specifically,

If J10 in sheet "Main" = "Option 1", hide all columns in all 38 sheets except columns A to W.

If J10 in sheet "Main" = "Option 2", hide all columns in all 38 sheets except columns Y to AU.

If J10 in sheet "Main" = "Option 3", hide all columns in all 38 sheets except columns AW to BS.

If J10 in sheet "Main" = "Option 4", hide all columns in all 38 sheets except columns BV to CQ.

If J10 sheet "Main = "ShowAll", show all columns in all 38 sheets....

Cell J10 in "Main" will be a drop down bar with the 5 choices.....

View 14 Replies View Related







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