Unhide Sheet Tabs After DisplayFullScreen = TRUE
Aug 10, 2006I want to restate the tabs after using DisplayFullScreen = true
and setting the commandBars ("").Visible = false
I would be very thankful for your Help as I'm newie to VBA in Excel.
ADVERTISEMENT
VBA To Hide / Unhide Tabs
Dec 11, 2011I am looking for a way to hide and unhide tabs. The first sheet of the workbook is an information sheet and I have a dropdown box in cell N3 to select Yes or NO to correct financial issues. If I select NO I would like to also hide tabs for sheet 4 and sheet 22.
I have used this for hiding rows:
If ActiveSheet.Cells(2, 2).Value = 0 Then Rows(146).Hidden = True
Can this be adapted to hide tabs?
Colouring Tabs Dependant On True / False Condition
Feb 21, 2010I have "borrowed" the below code from a previous solved post, however am unsure how to adapt it.
View 7 Replies View RelatedUnhide Sheet Based On Named Range In That Sheet
May 6, 2012Is there any way (in vba code) to unhide the sheet of a given named range?
If would come before the following line of code whee CurReference is already defined
Application.Goto Reference:=CurReference
Hide And Unhide Sheet According To A1 Value?
Apr 11, 2014i want to hide my sheet if A1.value = 0(zero) and if unhide the sheet if A1.value = greater than 0(zero)
View 11 Replies View RelatedVBA/macro To Unhide A Sheet?
Nov 15, 2008I'm having a challenge with a spreadsheet that puzzles me: I'm using this quite simple code to hide one of the spreadsheets (named "Ark2"). It written directly in a module as a subprocedure and there's no more code than this:....
View 4 Replies View RelatedUnable To Unhide Sheet?
Jul 12, 2012For the following code:
Code:
Sub ShowAdmin()
Sheets("Admin").Visible = True
End Sub
I'm getting the following error message:
Run-time error '1004' Unable to set the Visible property of the Worksheet class
Input Box To Unhide Any Sheet
Nov 29, 2012When User closes the workbook, it has to hide all the sheets except two sheets. THose two sheets are named as "Input Sheet" and "Button".
When User opens the workbook, he / she should be able to see only these two sheets and an input box needs to appear to unhide any one sheet. There will be 3 hidden sheets which will be named as, (1, 2 and 3).
While opening, If user inputs 1 in the inputbox then only the sheet named 1 has to be displayed along with "Input Sheet Button Sheet".
Hide & Unhide Button On Top Of Sheet ?
Feb 9, 2009I want to hide & unhide columns using only (plus minus) button which is appearing on top of current sheet. I have couple of files with that options built in, but I dont know how to do it. I tried to see macros but appears that there is no macros at all in that file??
View 3 Replies View RelatedVBA Hide / Unhide Rows On Other Sheet?
Jun 18, 2014 code:
Private Sub Worksheet_Change(ByVal Target As Range)
With Sheets("Sheet2")
Select Case Target.Address(False, False)
Case "B12"[code].....
I need to change it so that it hides a range of rows, say (6:26) instead of adding a line of code for each of the rows from 6 to 26 that I want to hide
Also how can I go about hiding the same rows on 5 more sheets, can I add more sheetnames after "Sheet2"?
Unhide All Sheets That Do Not Contain Certain Words In Sheet Name
Mar 11, 2009I pulled some code off the internet to “force” users to enable macros by hiding all sheets except a “Welcome Page”. It works great except that it also unhides sheets that are meant to be hidden by when the workbook is opened.
How would I adjust the following code so any sheets/ tabs containing the words “New Project” are not automatically unhidden? Below is the code pertaining to unhiding. I did not paste the code in its entirety as it is fairly long.
Option Explicit
Const WelcomePage = "Macros"
Private Sub ShowAllSheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If Not ws.Name = WelcomePage Then ws.Visible = xlSheetVisible
Next ws
Worksheets(WelcomePage).Visible = xlSheetVeryHidden
End Sub
Protect Sheet But Hide/Unhide Columns
Dec 17, 2008I have a speadsheet that has 27 columns for time entries, however employees seldom need to use more than the first 12 columns. I need to protect the sheet but would like the employees to be able to Unhide the columns when they need to use them, then reHide them. I can't find this as an option in either 2003 or 2007.
View 2 Replies View RelatedUnhide Row When Data Is Transferred Between Sheet By Macro
Apr 27, 2014I have the following code, it moves a row of data to another sheet based on a certain in the status column.
When the row is copied over to the other sheet, I would like when it pastes the data in to UNHIDE the row. This is due to the fact that at the current time all of the sheets have rows that are hidden unless there is data in them.
Is it possible you could add the unhide feature?
[Code] .....
Checkbox Macros Hide And Unhide On Another Sheet
Oct 22, 2012I would like to keep the current macros that I have and add the following:
A macros that can link the check boxes with the corresponding categories and rows in the other two sheets. If the box is checked the corresponding rows in the other sheets should appear.
I have color matched the check boxes with the rows on the two other sheets I would like to be linked up with.
Hide/Unhide Sheet When A Certain Cell Is Changed
May 28, 2009I am trying to create some code that will work each time a cell is updated. For simplicity, when cell A1 on Sheet 1 is greater than or equal to 25,000, I want Sheet 2 and 3 to be shown (they will already have been hidden). When A1 on Sheet 1 changes to less that 25,000, I want only Sheet 4 and 5 to be shown. I want to be able to change the number back and forth in A1 so only Sheets 2 and 3 show when A1 is >= 25,000, and only Sheets 3 and 4 to be shown then A1 < 25,000. I can't seem to find how to hide sheets based on a cell changing. I can only find how to permanently hide sheets.
View 9 Replies View RelatedHide / Unhide Columns On Protected Sheet
Feb 20, 2008When my spreadsheet opens it automatically protects the sheets using the following
With Sheet1
.Protect Password:=SpreadsheetPassword, UserInterfaceOnly:=True
.EnableOutlining = True
End With
and I use the following to hide the column if the toggle button on my form is 'true'. The problem is it gives an error if the sheet is protected. it worksfine without protection.
If ToggleButton1.Value = True Then
Range("column_calories").EntireColumn.Hidden = True
Else
Range("column_calories").EntireColumn.Hidden = False
End If
Unhide/Hide Sheet Based On Value In Cell
Apr 2, 2008I have a sheet called "Summary", there is a cell, AR8, of that sheet that is linked to other sheets. If AR8 of "Summary" has a value other than 0 I would like it to unhide. But if the value goes back to 0 again I would like it to hide itself again.
View 6 Replies View RelatedMacro To Check For True Value And Copy To Another Sheet
Oct 28, 2008I need a macro that would sort out the true value in column A, and paste it to another sheet (range A77)
View 10 Replies View RelatedHide Checkbox TRUE/FALSE & Sum Values Adjacent To TRUE
Aug 2, 2009I have a worksheet where I have around 300 rows, each with 7 columns. What I want to do is add a checkbox to each column. I plan on setting non-applicable checkboxes to mixed status and locking the worksheet. I will unlock applicable checkboxes and sumif or countif their value according to row-based scoring, for example, each checked checkbox represents a value of 3. I do not know VBA and have chose to use the form control checkboxes rather than ActiveX.
I believe that a formula for this would be something like: =SUMIF(B1:B3,True,"3") or =COUNTIF($B$1:$B$3,True)*3
I am wondering firstly if I have that right and secondly if there is a way to stop my checkboxes from displaying labels. Currently, if I click on one it displays True behind the active checkbox. If I uncheck it, it displays False.
Listbox Macro To Hide / Unhide Rows In Different Sheet
Jun 27, 2014In the attached abbreviated example, what should the second line in each of the three macros read to direct the hiding/unhiding of rows in the adjacent sheet? Right now I'm trying a If/Then configuration but it's not working. I was able to figure this out using grouped check boxes but a list box should be graphically "cleaner" and hopefully simpler in coding. The original table list is hidden in column "A", if that is important. I could use a combo box but the menu list is short and I think the list box approach will be simpler.... If there is a way to combine the three macros into one.
View 2 Replies View RelatedHide Or Unhide Worksheets From Cell Values In Sheet 1
Feb 18, 2009I want to set up a few workbooks with 11 sheets. Sheet 1 will in effect be an index, with True or False values in say cells D5:D14. The True/False values will be generated by form control check boxes in some of the workbooks and by IF(TODAY()>xxxx formulas or similar in other workbooks.
I then want to be able to hide or unhide sheets 2-11 based on the True/False values in cells D5:D14 in sheet 1.
Capture Cells From One Sheet Into Another. Hide/Unhide Sheets
Oct 9, 2009There is 2 parts to my question and I will explain them as best as i can.
1. I have a front sheet and 12 other sheets ( 1 for each month of the year) they all have the same layout. On my front sheet I want to create a button which will capture the sheet onto my front sheet for the current month, whether this means to make 12 buttons to choose which month is displayed on the front sheet or one that detects the date by system time i dont mind.
2. These 12 sheets will ideally be hidden and what I am wanting is again, on the front sheet 12 buttons for each sheet to bring up the corresponding hidden sheet so they can be viewed, and then on each of the 12 sheets another button which will hide them and return the user to the front sheet.
Allow Hide & Unhide Column/Rows On Protected Sheet
Sep 25, 2007I'm familiar with the code to allow grouping/ungrouping in a protected spreadsheet; http://www.ozgrid.com/Excel/outlining-protected.htm. How would I code to allow for hiding/unhiding cloumns and rows while still protecting the spreadsheet? Also, how could i allow for this file to be shared? Currently i'm getting an debug error when another person enters the file.
View 2 Replies View RelatedCopy And Paste Data From One Sheet To Another If Condition Is True?
Sep 17, 2013I need to copy the row data from sheet1, if the DEPT is HR and paste the same into sheet 2.
Qus:
data table ( Sheet 1)
SLEMP IDDOJ DEPT
1123419/17/2010HR
2123429/17/2010HR[code]......
Rename Sheet And Hide / Unhide Based On Cell Contents?
Feb 10, 2014I have a master sheet where users can change the name of 20 different sheets in the workbook by changing a cell value on the master sheet. Here is the code:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rCell As Range
If Target.Cells.Count > 1 Then Exit Sub
[Code]....
The next step which I am having issues with is hiding the sheets. I want all sheets in the workbook to be hidden except for the master. I only want the other sheets to be visble if the user inputs a name on the master sheet.
So if the cell contents on the master sheet, say "B9", is blank, the sheet in the workbook that corresponds to that cell will remain hidden. If the user inputs anything, say "Sheet1", in cell "B9" on the master sheet, I want that sheet to become unhidden and to be named "Sheet1"
Protect Sheet But Allow User To Unhide Specific Range Of Cells
Jul 19, 2014All, can I protect my worksheet while at the same time allow users to unhide a specific range of cells?
I'm hiding cell range FA:FK, but based on certain conditions I want to allow the user to unhide the cells but I do not want the user to be able to unhide any other hidden ranges. if there is a way to do this without using VBA. If it cannot be done with VBA
Sum Across Sheet Tabs
Nov 25, 2008Is it possible to Sum across sheet tabs, if so how?
View 8 Replies View RelatedCollating Tabs Into One Sheet
Dec 11, 2013I have a spreadsheet with around 250 tabs, all with a small amount of information on laid out int he same format. My question is can i collate this into one long tab?
View 5 Replies View RelatedHiding Sheet Tabs
Oct 13, 2008Hiding sheet tabs. can you hide tabs on excel?
View 4 Replies View RelatedLock Sheet Tabs Using VBA
Oct 13, 2008I need to get rid of the option to DELETE a sheet. However, when I password protect the WORKBOOK (which does this fine) none of the Macro buttons will execute, even with Macro security settings set to ENABLE ALL.
Looks like I will need some VBA code to not allow any of the sheets in the workbook to be deleted.