View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam (MS MVP) Edwin Tam (MS MVP) is offline
external usenet poster
 
Posts: 48
Default More Detail

Try

Sub Auto_Open(
Dim ws As Workshee
Application.ScreenUpdating = Fals
Application.DisplayFullScreen = Tru

For Each ws In Worksheet
If ws.Visible = True The
ws.Activat
Range("A1").Selec
ActiveWindow.DisplayGridlines = Fals
End I
Nex

Worksheets("Scorecard").Selec
ThisWorkbook.Colors(7) = RGB(255, 124, 128

Application.AutoPercentEntry = Tru
End Su

Sub Auto_Close(
Dim ws As Workshee
Application.DisplayFullScreen = Fals
ActiveWindow.DisplayWorkbookTabs = Tru
For Each ws In Worksheet
If ws.Visible = True The
ws.Activat
Range("A1").Selec
ActiveWindow.DisplayGridlines = Tru
End I
Nex
Worksheets("Scorecard").Selec
End Sub