Splash Screen Do Not Show Again Checkbox
Sep 27, 2009
I have a SplashScreen that is activated in the ‘Workbook_Open ‘ Event.
A CheckboxControl on the SplashScreen allows a user to disregard the screen the next time the workbook is opened.
Private Sub Splash_Screen_Activate()
If Splash_Screen.ckbx_StopSplashScreen.Value = True Then
Splash_Screen.Hide
Else
If Splash_Screen.ckbx_StopSplashScreen = False Then
Splash_Screen.Show
End If
End If
End Sub
Unfortunatley my code is not working. I was hoping for some insight into making this work. Mind you, I’m a cut and paste VBA type of person, but I do understand the concepts enough to work with it.
1.What is the proper method for coding this?
2.Which location would this code be placed – the Form itself or a Module?
3.How and where do you store the CheckBox Value to be used the next time the Workbook is opened?
View 9 Replies
ADVERTISEMENT
Nov 22, 2008
I have never created a splash screen and would like to do so now, I am in the VB editor, i have inserted a userform, i would like to insert my company logo on to the userform, how do i do this?
View 9 Replies
View Related
Jun 5, 2014
How to get a Splash to show on WB open without seeing the Excel worksheets briefly flash before the splash loads.
(Note you will still see the Excel loading window prior to the splash appearing but I don't worry about that).
View 3 Replies
View Related
Aug 19, 2006
I cooked up a nice little splash screen using a user form. It seems to be left of center on the screen when it pops up. Is there a way to set the x and y coordinates to 'place' the splash where I want it to go?
View 3 Replies
View Related
Sep 24, 2009
I searched for this and found a few examples on splash screens, but if someone could help I would appreciate it.
Basically I have this massive macro that runs, I recorded some of it, and VBA the rest. It does a bunch of things like bringing in different spreadsheets, formatting vlookups blah blah blah... Anyway for a nice touch I was hoping that I could get a splash screen or something that will run while this macro is running in the background. How hard would this be? The macro is button driven...
View 9 Replies
View Related
Aug 25, 2007
I have recently finished a program in excel and when my users dbl click the icon on the desktop, excel loads with their splash screen. Is there any way of replacing their screen with one of my own?
View 2 Replies
View Related
Mar 26, 2008
i have a spreadsheet which i have attached, currently users have to filter each column to get the end result
I would instead, like to create a screen where by they answer questions, for example. a drop down box where they choose flow rate, ie. 0-5l/min 6-10 l/min and so on for each option and then they end up with the list of choices which meet their criteria
View 12 Replies
View Related
Feb 3, 2010
I have a workbook with several user forms. When the workbook opens I'd like to show frmSplashScreen for 3 seconds then close and have another form frmMain show. I've tried the following code and it opens frmSplashScreen ok but it does not automatically close the form. If I click the close box then in 3 seconds frmMain will show.
View 3 Replies
View Related
Sep 27, 2011
I have a splash screen I want to display while a macro runs. I've created all the necessary code based on information from this site but have a question about where to actually put the code as all the example I've seen are based on workbook open events.
I tried placing my code
UserForm1.Show
with in the macro I waned the splash screen to be displayed during but that doesn't work. Well, it does, but not as I intended. The splash screen pops up for the specified duration as part of the macro stopping the macro, then closes and the rest of the macro finishes running.
Do i need to call the splash screen from a certain point in the macro I wish it to be displayed during? I dont want the macro to stop running while the splash screen is showing.
View 1 Replies
View Related
Sep 11, 2009
I have created a splash screen. Is it possible when the excel workbook is opened up that only the splash screen shows? Right now, the workbook opens and there is one sheet that is visible for a certain period of time and then the splash screen comes on. I would like the reverse to happen. First the splash screen and then the one sheet.
View 9 Replies
View Related
Sep 1, 2006
is there anyone who knows a sophisticated way to hide the application
while showing a little splashscreen on startup
y already have this code but it causes a flickering, not very nice
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Application.Visible = False
frmShow
Application.Visible = True
Application.ScreenUpdating = True
End Sub
is there maybe someway to get into the clickevent off the excel.xls file
View 4 Replies
View Related
Sep 4, 2006
Some time ago (not sure how long ago) I created a splash screen that comes up when I first load a particular workbook. There was only one worksheet in the workbook and at that time the data in the worksheet was not so relevant and hardly ever used. That workbook name is "Employees" and the worksheet name is "EmpData".
Subsequently, the worksheet ("EmpData") in the workbook "Employees" has became relevant to a new workbook named "Payroll" I created. This workbook is used all the time. It had four different active worksheets.
I realized last week that the data in "EmpData" was very relevant to the work in the "Payroll" workbook so I copied "EmpData" worksheet in it's entirety to the "Payroll" workbook as a fifth worksheet using the same name as before, "EmpData". Now each time I open the "payroll" workbook the splash screen shows up and hangs around for several seconds or longer. It has become quite irritating and I want to delete it.
View 3 Replies
View Related
Feb 2, 2014
how to get rid of the blinking cursor in a text box. I made a splash screen, added a text box, increased the font size to maximum, and when I run it there is a maximum sized blinking cursor at the end of the line of text. Just looks bad on the splash screen. Is there a hide cursor command that I can use? Or is there a better way to add text that I (obviously) didn't use?
View 1 Replies
View Related
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
Feb 16, 2009
Hi, The purpose of this macro was to control the time this excel file was open because many users modify it. I decided to create a splash screen (userform) to display a message to the user saying "your session time of 15min is up"
The problem is, the first time I open the file everything works fine. But after I close it (just the workbook not excel), It opens itself for some reason and gives me a debug error message. Perhaps the timer is never stopped?
I call "StartTimer10min" on workbook open and "StopTimer" before workbook close.
View 11 Replies
View Related
Nov 20, 2008
My Splash screen opens a few seconds after the workbook has loaded. Is there a way to make the workbook open minimzed until the the splash screen closes then open properly? What I trying to say is that only the splash screen is visible until it closes.
View 5 Replies
View Related
Jun 13, 2006
I am trying to display a splash screen which fades in and then fades out and closes itself leaving the ap showing. I have utilized code that I found wih permission to use but I'm still doing something wrong.
Option Explicit
'// This Userform code has everything you need to make a captionless userform
'// Fade In & Out
'// Transparency
Private Declare Function SetLayeredWindowAttributes _
Lib "user32" ( _
ByVal hWnd As Long, _
ByVal crKey As Long, _
ByVal bAlpha As Byte, _
ByVal dwFlags As Long) _
As Long
'// Title Bar
Private Declare Function GetWindowRect _
Lib "user32" ( _ ..............................
View 7 Replies
View Related
Feb 3, 2008
I have a splash page I created and I work on dual screen monitors. Typically I have Excel open on the left monitor and my VBA window (alt-F11) open on the right. If I close my Excel workbook and reopen it, the splash page will always open on the screen that had the VBA window on last. In my case Excel opens on the left monitor and the splash page shows up on the right window. I would like to have the splash page open on the side that Excel opens on (in my case the left side). Wondering if there is some VBA code I can add in my splash page code that would allow me to override this default setting?
View 2 Replies
View Related
Aug 17, 2006
On a spreadsheet in excel from office xp, is it possible to display a row on the screen, but when you print the sheet it doesn't get printed? How do I do that?
I tried hiding the row, but the admin wants to be able to see it on screen and complained too tedious to unhide it on screen then hide it for printing.
I have never written macros for excel so not sure if there is a solution there, or if it can be done another way.
I also thought we could have the data from the row in another sheet that doesn't get printed, but she (the admin) preferred the hide/unhide solution.
View 3 Replies
View Related
Jun 13, 2013
So I was wondering if there is a way to show text on the screen while viewing/editing the workbook, but to not show those specific CELLS while printing.
View 4 Replies
View Related
Sep 4, 2007
is there a way i can make my user form in full screen? i already drag it to it's full screen but i still can see the blue tool bar with X (close) button i also want to run the macro when i open the file i want it to run automatically with full screen....
View 7 Replies
View Related
Sep 25, 2007
I'm having trouble centering my UserForms on the screen. I have tried all the options on the StartUpPosition in the Properties windows and the closest I can get is vertically centered but on the far left. The annoying thing is that it was working (both vertically and horizontally centered) but when I changed the defaults of the option buttons they moved to the position I described. I have two monitors (but excel is maximised on one monitor only) could this have something to do with my problem? If so why did it work before?
View 6 Replies
View Related
Apr 23, 2008
I have a very large workbook with multiple sheets and use macros to copy and paste all data as values, then delete some rows and columns depending on certain criteria. This starts at cell A1 and works right, then down.
This is then saved as a copy and distributed to a wide audience.
The problem is that when each page is opened up, the data shown is the bottom right of the whole sheet instead of the top left ( Panes are frozen for row and column headers).
View 9 Replies
View Related
Mar 23, 2007
I am trying to do is create a button that when pressed, will bring up the Find screen (which can be brought up by pushing ctrl + f)...I tried to record it as a macro but nothing came up.
View 9 Replies
View Related
Jun 30, 2008
I have a VBA code that copy data from multiple files into my workbook.
I find the first file, copy the ranges I need into my workbook and continue to the next file until all files are done.
The copy operation in each file is - row by row - because I need to ask questions about each row.
As you understand - what the user sees is a flickering window because I activate the source workbbok -> copy the data -> activate this workbook-> paste the data.
I want to avoid the flickering.
An acceptable solution could be to generate a pop up message box that will say "data is being copied. Pleasd wait while operation is completed". BUT - I don't know how to identify that the action is done and message box can be closed.
View 8 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
Dec 25, 2009
I have multiple check box (activex control). When click to first check box second should appear and linked to corresponding cell in column K. I did that manually
Is here the way to do tah using more complex
View 4 Replies
View Related
Aug 8, 2006
code to write down to make a checkbox hide the text in a few cells..
What I want is..
When I tick the check box I want it to show me the text in the cells (C11:D11 to be specific) and then when I untick it I want it to hide the text so all you can see is the background colour.
Here is the attatchment of what I have so far:
View 4 Replies
View Related
Jan 29, 2008
I have a userform labels role_selection with 5 checkboxes. Each checkbox with the caption labels as follow: Students, Teachers, Below Average, Customer, and Friend.
In addition, a 3 worksheets each labels as follow: Main page, General, and Final.
The General worksheet has the same name as the 5 checkboxes (Students, Teachers, Below Average, Customer, and Friend).
My question is how can i write a program to determine which checkbox is selected and compare the selected checkbox caption to the names that already existed in the general sheet. If the name exists show that name and hide the rest ...
View 9 Replies
View Related
Mar 18, 2009
I received a spreadsheet form containing some checkboxes that I need to tick. The problem is I dont know how can I tick/show the check mark on the checkbox. everytime I double click it, macro vb screen appears.
View 4 Replies
View Related
