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
ADVERTISEMENT
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
Aug 29, 2006
I want to zero out or blank out my running balance in the columns where I do not have an amount entered. So instead of having my running balance total run all the way down the spreadsheet, I want it to be blank at the first cell where I have not entered in a new bill. I have attached an example of what I am trying to do.
View 2 Replies
View Related
Jan 30, 2014
Excel 2007.
I have a workbook with a sheet per day, each sheet has a variety of 'jobs' as columns and a variety of people and kit as rows. Hours are manually input each day during the month.
Simplified version... These are two separate sheets 'M060114' and 'Tu070114'.
Monday
Dig
Drive
Dave
4
5
Bill
2
7
Tuesday
Dig
Drive
Dave
2
7
Bill
8
1
I have a Pivot Table on a separate sheet. This was created using the Wizard (ALT +D +P).
Dig
Drive
Dave
6
12
Bill
10
8
So far, lovely.
But when I double-click on a number or right-click and choose 'Show Details' I don't get the sheet names in the newly created information sheet. I get the Row label, column label and a list of the entries.
So if I clicked on 10 above...
Row
Column
Value
Bill
Dig
2
Bill
Dig
8
That's fine with just a couple of entries but with about 80 columns and 250 rows spread across a month, therefore 30ish sheets, it's difficult marrying up the 'Show Details' sheet to the actual data.
So after all that, the question. Is there a way of getting the sheet name to appear in the 'Show Details' information sheet?
View 1 Replies
View Related
Jun 28, 2006
I have included the table. What I want to do is in a user form pick a county ie Devon, Then by clicking "go" all entries that contain "Devon" are then copied to a " sheet 2" I don't want to use the Ctrl-F
View 2 Replies
View Related
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
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
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
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
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
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
Mar 20, 2009
I have an excel 2003 sheet that collects data from Infopath forms. The forms are to record students who have broken school rules, when, where, repercussions etc. One column shows their class and there is a separate column for each rule broken.
I want to create another sheet to show each class down the rows and the columns to show each school rule. Therefore, each cell would show the number of each particular rule broken for each particular class. I have tried to do countif and sumproduct (if on sheet 1, column B the class is KA and on sheet 1, column M, the rule is bullying = how many times this has occurred).
View 9 Replies
View Related
Jan 5, 2012
I've got a workbook which runs several macros and take approx 10 mins to run. I was wonder if its possible to put a timer in the status bar which shows how long the macros have been running.
View 9 Replies
View Related
Aug 30, 2006
Is it possible to show a timer on a worksheet as a user inputs to it? I can get the timer to appear, using Application .OnTime Now() + TimeValue ("00:00:01"), "AutoRecalcWorkbook", but it's kind of modal -- that is, the user can't input at the same time it's running.
View 2 Replies
View Related
Nov 12, 2013
I am trying to insert a timer into a column cell range that will countdown in hours, mins, and sec, when I enter the time. example: when I enter the "time in hr,mins,sec" it will start to countdown to Zero automatically, when I hit the enter key.
View 3 Replies
View Related
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
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
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
View Related
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
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
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
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
Oct 20, 2006
How do you hide a sheet?
View 6 Replies
View Related
Mar 29, 2007
I am trying to write a code for a dropdown box where only the sheet selected from the dropdown is visible. Then, when you select another option from the dropdown, that sheet is the one visible (and all others are hidden).
View 9 Replies
View Related
Oct 9, 2008
I have a query Work sheet that has the names of my worksheets in the following format.. mmm dd, yyyy H15 has a formula that returns the sheetname as a value. What Id like to have is a checkmark that when checked it will take you to that worksheet. Ive played with it and came up with the following...but its not working...any advise??
Sub SHOW_H15()
'
Worksheets("Query").Range("H15").Text .Select
End Sub
Also id like to have the check mark named as "Would you like to see (h15) 's worksheet?"
One more thing...if a value is in H15 Id like the checkmark box to appear. If nothings in H15 dont show the checkmark Box.
View 9 Replies
View Related
Jan 22, 2009
I'm trying to show a sheet based on a value from a sheet.
Sheet1 cell k2 will have a month as digits "01".
I have added a command button to the sheet. This is the code attached to the command button:
Private Sub CommandButton1_Click()
Dim datepage As Range
Set datepage = Range("K2")
Sheets(datepage).Visible = True
Sheets(datepage).Select
End Sub
What it suppose to do is, if cell k2 contains "products", it will open up sheet "products". There are over 30 sheets that will be involved with this script. Just showing 1 example.
As it stands the script is not working, what could I be doing wrong here?
View 9 Replies
View Related
Jun 11, 2008
I have used VBA and can do basic programming, but have no experience with popups beyond msgbox.
I've written a macro that I want to run, but it needs an input. This input is a worksheet name. What I want to do is run the macro, have a popup that has a combo box ask me to select which worksheet I want, either click ok and save that worksheet name to a variable or click cancel and exit the macro.
My Pseudo code looks like this:
Run Macro
Combo Box Popupoption1=sheet1option2=sheet2option3=sheet3If OK ThenSelection = Combo Box choiceElseIf Cancel ThenExit Sub
...Macro Code....
View 9 Replies
View Related
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
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
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
