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


ADVERTISEMENT

The Workbook Open Minimzed Until The The Splash Screen Closes Then Open Properly

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

Workbook Is Opened Up That Only The Splash Screen Shows

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

Splash Screen

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

Improved Splash Screen?

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

Repositioning Splash Screen

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

Splash Screen While Macro Runs?

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

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

Replace Default Splash Screen

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

Create Splash Screen With Filter Spreadsheet

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

Splash Screen Closed With Timer Event

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

Splash Screen - How To Display While Macro Runs

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

Avoid Seeing Application While Showing Splash-Screen

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

Delete Splash Screen UserForm & Code

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

Removing Blinking Cursor From Textbox On Splash Screen?

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

Open App From Another Workbook - Screen Refresh

Oct 29, 2008

I've developed a complex dictator application, which pretty much takes over the entire Application object. During beta testing, I've had some user complaints that, once my program is started, they can't access their existing workbooks.

In order to remedy this situation, I'm trying to construct a front-loader workbook, which will automatically determine whether or not to start a new instance (application) of Excel. If the user already has a workbook open (i.e. "MiscBook.xls"), the front-loader will start a new application; otherwise, it will just use the existing application.

My "Auto_Open" code for the front-loader workbook is shown below:


Sub Auto_Open()

Dim xlApp As Excel.Application
Dim wbkTemp As Workbook, wbkApp As Workbook
Dim lCount As Long
Dim vTemp As Variant

The code works fine, but I have a minor gripe: every time a new application is created ("Else" in the "If-Else" above), the screen doesn't appear to refresh. In other words, I get a new window (instance of Excel), but none of my custom-defined buttons and menus show up. If I hover my mouse over their intended locations, they "appear" one at a time.

I'm just wondering - is there something I can do to prevent this behavior, or "refresh" the new application window upon startup? I'm essentially looking for something like "Userform.Repaint", only for a brand-new Excel Application object.

View 9 Replies View Related

Hide Workbook Opening/closing Operation On The Screen

Jul 6, 2007

I am running a script that populates about 70 or so workbooks based on information from the database. Naturally this script is quite slow but what seems to take the most time is opening and closing workbooks. Is there a way to "hide" the workbook opening/closing operation on the screen? I have tried using the

Application. ScreenUpdating = False

this sped the code up but you still see the workbooks opening on the screen.

View 2 Replies View Related

Always Open Workbook In Full Screen Mode?

Feb 12, 2014

I already have a couple of VBA commands on my sheet. so I've tried to add:

[Code] .....

but this isnt making the sheet automatically go full screen.

View 2 Replies View Related

On Workbook Open Change To Full Screen?

Feb 20, 2012

How can I make excel go to full screen (Alt-W-E) as soon as a workbook is opened and then revert back to normal view when it is closed? I already have this code in my workbook_open event just in case that will affect the answer:

HTML Code:
Private Sub Workbook_Open()
If Not LockSheet(ThisWorkbook.ActiveSheet) Then Exit Sub

[Code].....

View 7 Replies View Related

Open Workbook In Full Screen Mode

Jul 23, 2004

I like a particular workbook to open in full screen mode.

How would I do that?

View 9 Replies View Related

Open & Close Workbook Without Screen Flicker

Jan 10, 2008

I have a userform that opens a woorkbook and fills some textbox from that woorkbook. Although that it goes very fast it is still visible (sometime just in the toolbar) and flickers the screen. Is it possible to open it "hidden"?

Private Sub UserForm_Initialize()
Application.ScreenUpdating = False
On Error Resume Next
Workbooks("Kontrollsystemet.xls").Close SaveChanges:=False
Workbooks.Open "V:allaBeredningKontrollsystemetKontrollsystemet.xls", ReadOnly:=True
Sheets("Calc").Activate
Label4 = Range("K7")
Label5 = Range("L7")
Workbooks("Kontrollsystemet.xls").Close SaveChanges:=False
Caption = Now
TextBox1.SetFocus
Application.ScreenUpdating = True
End Sub

View 3 Replies View Related

Session Timer 10min Splash Screen Warning Then 15min Force Close

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

Display A Splash Screen Which Fades In And Then Fades Out And Closes Itself Leaving The Ap Showing

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

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

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

Macro To Hide Sheets In Workbook

Jun 3, 2014

I have a workbook that I edit daily then pass along to another team. All of my modules are passwork protected and there are also several sheets in the workbook that I hide before email it to the other team. I hide the sheets by changing the sheet properties in the VBA editor to "2 - xlSheetveryhidden".

This isn't a very time consuming process but I am wondering if there is a way to automate it through VBA?

I tried the the fail safe of "see what happens when I record it" but all I got was an empty Module.

View 2 Replies View Related

Open Specific Sheets In A Workbook?

Aug 30, 2013

I have a work book with many sheets and staff continue to mess this up so I would like to know how I can have a specific sheet called Instructions open when this workbook is opened preferably no macro's is this possible

View 7 Replies View Related

On Workbook Open Protect All Sheets?

Feb 19, 2012

Is there a simple one line VBA code to protect all sheets when a workbook is opened?

View 5 Replies View Related

Workbook Open Clear All Sheets

Apr 28, 2006

Im looking for a Workbook_Open event that will "clear all" on every sheet.

View 3 Replies View Related

On Workbook Open Delete All Other Sheets Except For Data

Oct 25, 2011

VBA code that would delete ALL other sheets in the workbook except for Sheet "Data".

View 2 Replies View Related







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