View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
miker1999[_11_] miker1999[_11_] is offline
external usenet poster
 
Posts: 1
Default What to use other than .Select

Hello,
I have some code that runs on Workbook Open that goes to a few sheet
and turns on Freeze Frames and Hides some columns. The way I currentl
have it coded...works, but it quickly flashes through the sheets. I
there a different way to code this so it doesn't flash through th
sheets?

Here is a sample of the code. Help!


Private Sub Workbook_Open()
Worksheets("1-OPEN").Select
Call Freeze_Frames
Call HideColumns_All
Worksheets("COMPLETED").Select
Call Freeze_Frames
Call HideColumns_Al

--
Message posted from http://www.ExcelForum.com