Flash Screen

Pondcroft13

New Member
Joined
May 27, 2010
Messages
32
Hi All,

Any idea what may be wrong with the code I am using below. The items below showing red are what are showing red in Visual Basic so I am guessing this is where the issue is.

Private Sub Workbook_Open()
'open at a sheet (and range) you want regardless
'of whether or not the sheet has been renamed

'Set the sheet to open (use its codename here)
Const StartUpSheet = "Dynamic UI"

'Set the cell to activate
Const StartUpCell = "A1"

Dim N&
For N = 1 To Sheets.Count
If Sheets(N).CodeName = StartUpSheet Then
Sheets(N).Activate
Range(StartUpCell).Activate
Exit For
End If
Next

Dim frmSplash As GPUActionsLog
‘Show the form modelessly
Set frmSplash = New GPUActionsLog
frmSplash.Show vbModeless
‘Process the startup code
Application. Wait Now + TimeValue(“00: 00: 5”)
‘Unload the splash screen
Unload frmSplash
Set frmSplash = Nothing

End Sub

Kind regards,

Chris
 
Last edited:

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You need a single quote for a comment:

'Show the form modelessly

Not sure what character you have - probably from HTML.
 

Pondcroft13

New Member
Joined
May 27, 2010
Messages
32
Great Andrew - You were 100% correct - I did paste this from HTML - Great Spot.

Kind regards,

Chris
 

Forum statistics

Threads
1,136,331
Messages
5,675,156
Members
419,552
Latest member
jsanjur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top