Hide One Sheet And Open Another

May 8, 2014

I have been reviewing various methods of doing this and I had one that worked and for some reason it has now stoped?

The Code is:

Sheets("BCDashbd").Select
Sheets("Main Dshbd").Visible = True
Sheets("BCDashbd").Select
ActiveWindow.SelectedSheets.Visible = False

This is activated by using a button on the BCDashbd Page. I want it to hide the BCDashboard sheet and Unhide the Main DshBd Sheet. Currently it opens the Main Dshbd sheet but does not hide the BCDshboard Sheet?

What have I missed?

View 3 Replies


ADVERTISEMENT

How To Have Open Hidden Sheet / Hide On Closing

Feb 24, 2014

I've got this function where you can select from a list of names, and when you press go it unhides the sheet and goes to it, problem with that was after closing the sheet it was no longer hidden. So now, I have

[Code]......

So when you press go, it unhides the sheet, goes to it, and hides it again, but then the sheet is hidden it pushes the user back to the page they was on, so it would appear you can't have a hidden sheet open.

Is there a way for excel to determine when the sheet has been closed, to be able to hide it when the user navigates away?

View 6 Replies View Related

Open Another Sheet And Hide Rows Based On Cell Value?

Oct 29, 2013

I wish to have a button on one sheet wich opens another sheet and hides all rows without "NO" in F4:F300

Starting code for button below:

VB:
Private Sub Kilaneset_Click()
Sheets("MSDS").Visible = True
Sheets("MSDS").Select

View 6 Replies View Related

Open Formula Sheet And Hide All Sheets Except Clicking Hyperlink

Feb 22, 2013

I have a file having around 57 sheets.But here,I have taken a example.I want a file whose show me only summary sheet.But when,I click the cell no.C7 then the related sheet should be open i.e.FNDADRSCC,and all the sheets should be hide.I have little knowledge of HYPERLINK formula but not to the desired stage.

For more clarification, refer attached file.i.e. BOM Sheets

Desire result file have attached also i.e. Excel_formula

View 1 Replies View Related

Hide On Open

Jun 11, 2009

Ok what i would like is when i open a certain excel file it hides the command bars the sheet prity much all of excel. though Must still be able to show the userform.

View 9 Replies View Related

Open Userform And Hide Application

Jan 31, 2014

I have got a Useform. I want on Sheet1 when i click on Userform button to open it ; then excel application should be hide and only userform should be show.

I do not want it on startup.

I have attached Excel worksheet with userform.

View 2 Replies View Related

Open, Hide, Unhide, Close

Oct 22, 2008

this has to be the easiest thing ever. I want to (on opening one file) open another, and hide it (the second file), and then when closing the first file, I want to close the second file as well....

View 9 Replies View Related

Hide All Rows/Column All Worksheets On Open

Oct 17, 2006

are there means to make visible the hidden rows and columns on all sheets
when the workbook is opened?

View 9 Replies View Related

Open Workbook - Hide Sheets/splash Screen

Oct 6, 2009

I have a workbook that has worksheets that serve as data input pages for the user.
I have control boxes created by the forms toolbar.

I created a splash screen that is to be launched when the file is opened.
Instead, often the last sheet that the user was on when they last saved the file (usually but not always the worksheet called "Main Menu") is seen first.

I understand that not all the sheets can be hidden - that one must be unhidden.

So I created a sheet called "Background" that is a solid color with no gridelines.

Objective:

When the file is opened, I want the "Background" sheet to be seen first and then the splash screen to be initiated.

Now - when the user opens the file, the Main Menu worksheet is seen for a few seconds (or whatever the last sheet was on before it was last saved), then it disappears and the solid background screen is shown with the splash screen. When the splash screen ends, the "Background" sheet disappears.

Here is the code that I have in the workbook

Private Sub Workbook_Open()
Dim wks As Worksheet
On Error Resume Next
For Each wks In ThisWorkbook
If wks.Name "Background" Then
wks.Visible = False
End If
Next wks
End Sub

What has to be changed so that the first sheet that is seen upon opening the file is the "Background"; then the splash screen happens; then it returns to the Main Menu sheet?

View 9 Replies View Related

VBA To Hide Rows If Date In A Cell Less Than Today On Workbook Open

Apr 30, 2013

I'm trying to create a workbook which has dates in column B, starting with row 10. I'd like to have a code which will hide the rows if the date is less than today upon workbook open. This would need to apply to worksheet1 only.

View 1 Replies View Related

Rename Sheet - Hide It - Create Copy Of Same Sheet

Dec 21, 2011

I have about 100 products and each has its own sheet that I fill with data. Once I have finished with a sheet I rename it and create a copy and then hide the original and delete the entered data from before and start over.

Is there a way I can make it so when I hide a sheet it will automatically create a copy and delete a specific range?

View 1 Replies View Related

VBA To Hide Sheet In Workbook And Copying Hidden Sheet

Dec 12, 2013

I have a userform which clones the latest sheet and produces copy of it on the next sheet. The first sheet they will be cloning is the sheet called 'template', I however want this to be hidden since I do not want anybody to modify a sheet which basically serves purpose of a template. And once cloned, it is no longer needed.

On the click of the command button, the macro will create sheet1 taking the info from sheet named 'Template' in the same workbook . And now on the next click of the command button, Sheet 2 is created taking the info from sheet1 and Sheet 3 is created taking the info from Sheet 2 and so on. Here is what I currently have, so how can i modify it in order for my scnerio to work?

To select the last sheet in the workbook

Code:

Sheets(Sheets.Count).Select
To create new sheet

Code:

Sheets(Sheets.Count).Copy After:=Sheets(Sheets.Count)Sheets(Sheets.Count).Name = MyEvent & " " & MySCN & "(" & ThisWorkbook.Sheets.Count - 2 & ")"

View 3 Replies View Related

VBA - Show Timer On Sheet Then Hide Sheet

Oct 15, 2012

I have a sheet named SEND FORM that has some info that I would like for the user to see for about 10sec when he opens the work book and then it will hide and show the sheet they will be working in named STOCK CUTTING FORM.. Also is it possible to have the 10 sec timer to be shown in cell L12 in the SEND FORM sheet... I already have a couple of things in my open event which are below

Code:
Private Sub Workbook_Open()
Call RunOnTime
Call ShowMsg
End Sub

View 2 Replies View Related

Automatically Hide Sheet When Select Other Sheet

Jan 14, 2013

is it possible to hide a sheet automatically if i select the other sheet. For example, I have sheet1, sheet2 and sheet3, I'm at sheet2 and if i select the sheet1, sheet2 and sheet3 will automatically hides.

View 4 Replies View Related

Hide Tab Sheet If Cell In Another Sheet Equals Certain Value?

Feb 18, 2014

I'm right now trying to find a way to hide a tab sheet if a cell in another sheet equals a certain value. I cant seem to find the macros for this?

Basically,

If Sheet1 cell A1 = "No" then hide Sheet 2

View 5 Replies View Related

Hide Sheet Based On Cell Value Of That Sheet

Jun 21, 2008

can a macro hide a worksheet if a cell in the sheet that I want hidden has a certain value?

View 9 Replies View Related

Macro To Copy Current Sheet, Create, & Rename New Sheet From Current Open Sheet

Oct 27, 2008

EXAMPLE: Complete Sheet called "Day1". When day1 is complete you click on button and it then copies itself and creates and renames new sheet to "Day2", then when "Day2" is complete you click on button and it then copies itself and creates and renames new sheet to "Day3", and so on and so forth to "Day30".

View 9 Replies View Related

Open New Sheet With Data Off Of Existing Sheet?

Feb 5, 2012

I am trying to prepare a Worksheet that has an initial sheet which is a summary of all sheets, information on individuals and totals etc. This summary sheet will be added to over time. I would like it so that when I enter the details of a new individual on the summary sheet a new sheet is opened following a template with the details already filled in for that individual, and for the new sheet to be named with the individual's name. Ideally the new sheet would open automatically once the info has been entered, either that or a button to open the new sheet,

View 3 Replies View Related

Macro To Hide A Sheet If A Value On That Sheet Is 0

Apr 2, 2008

I have a sheet, call it summary, that I need filled out if a value on it in A1 is not 0. Summary is linked to other sheets and inputs on those other sheets makes A1 change. So what I am looking for is a way to make summary appear if the value of A1 <> 0. If A1 goes back to 0 I need summary to hide itself again.

View 9 Replies View Related

How To Hide Sheet Tab.

Oct 3, 2009

i am using hyperlink in sheet 1 name history and sheet 2 name advance sheet 3 total progress..i want to hide the tab for selection by mouse.how to hide this tab,so user will click only the button that hyperlink.

View 3 Replies View Related

Hide And Unhide Sheet According To A1 Value?

Apr 11, 2014

i 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 Related

Hide & Protect Sheet

Jul 18, 2009

I'm trying to protect a sheet so that it can be unhidden only if you know the password.

This is because I have a macro that updates some of the cells and there are some people (and only those) that should be able to access it quickly and easily. -> can't use VeryHidden or cell lock.

View 2 Replies View Related

Hide Sheet Whenever Not Active?

Dec 27, 2013

I'm looking for VBA code that will:

Hide a sheet whenever it is not the active sheet

View 3 Replies View Related

If A Range = 0, Hide Sheet

Dec 21, 2007

If Range A1:a10 On Sheet 1 = 0, Hide Sheet 1

Anybody Know The Code To Do This In Vb?

View 9 Replies View Related

VBA To Hide Columns On Second Sheet

Jun 4, 2009

I'm trying to hide columns M:R on sheet "1up" if cell N4 on sheet "Fill In" is blank and unhide those columns if N4 contains an "X". Columns AK:AP should also hide or unhide on "1up" if AD4 is blank or not on "Fill In".

I've pieced together the below code by recording macros and piecing together code I've found in other threads on here. I placed the code in Sheet 1 (Fill In).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("N4").Valuse = "X" Then
Sheets("1up").Select
Columns("M:R").Select
Range("M7").Activate
Selection.EntireColumn.Hidden = True
End If
Sheets("Fill In").Select
Range("N4").Activate
If Range("N4").Valuse = "" Then
Sheets("1up").Select
Columns("M:R").Select
Range("M7").Activate
Selection.EntireColumn.Hidden = False
End If
Sheets("Fill In").Select
Range("N4").Activate
End Sub

View 9 Replies View Related

Hide Sheet/Worksheet

Oct 20, 2006

How do you hide a sheet?

View 6 Replies View Related

How To Hide Decimals To Show In A Sheet

Jan 10, 2014

I have a some data in 1st column in which most of the data has decimals. For ex. 209.8, 224.4 like this. I have converted it by roundup function and get the exact result. I want to hide the decimals means not show decimals. Only the result will show like. 210, 224 etc. For your reference I have attached the sheet. I have manually typed this in the C column result area. That I need in A column.

View 9 Replies View Related

Hide Sheet As Per System User Name?

Mar 22, 2014

I have a challenge in excel functions, I need to save a file as common folder but in that workbook have multiple sheets need to show the sheets as per the user name on system other sheets want to hide with password protect,

example,

file name:- Report
Sheets:- A,B,C,D

if now using system user name is A then need to show only "A" sheet, other sheets want to be hide and the same for all.....

View 2 Replies View Related

Hide & Unhide Button On Top Of Sheet ?

Feb 9, 2009

I 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 Related

Protect And Hide Sheet In Workbook?

Apr 26, 2009

I've stored all my on-line passwords (about 50 of them) in one sheet in an Excel workbook. I want to protect it so that if somebody somehow got access to it, they couldn't see the sheet, much less change anything.

I tried Tools/Protection/Protect Sheet and Tools/Protection/Protect Workbook, using a secret password. Then, nobody could change the data -- but they could still see it.

So then I hid the columns first, and then protected the sheet -- which did the trick. But that seems pretty cumbersome, because it involves two steps for me to open it up (unprotecting and then unhiding).

Is there a way to protect/hide in just one step so my sheet of passwords can't be seen by an intruder?

View 6 Replies View Related







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