Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using the following code to hide the "WelcomePage" (dim'ed as a const).
However, I'm unable to remove the momentary "flash" of the "WelcomePage" before it is hidden. Using Application.ScreenUpdating doesn't seem to help. Any suggested changes to the code to remove the unwanted "flash" of that sheet? Thanks, Jack Private Sub ShowAllSheets() 'Show all worksheets except the macro welcome page Dim ws As Worksheet Application.ScreenUpdating = False ' added For Each ws In ThisWorkbook.Worksheets 'If Not ws.Name = WelcomePage Then ws.Visible = xlSheetVisible ws.Visible = xlSheetVisible Next ws Worksheets(WelcomePage).Visible = xlSheetVeryHidden Application.ScreenUpdating = True ' added End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Screen / Display "TRUE" "FIX" | Excel Discussion (Misc queries) | |||
Stop the "flashing" when I execute an Excel macro? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
On Window change, a "flashing" screen | Excel Programming | |||
Screen "Flashing" on Window change | Excel Discussion (Misc queries) |