Thread: AUTO_OPEN
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Barnes Bob Barnes is offline
external usenet poster
 
Posts: 134
Default AUTO_OPEN

I'm running Access automation to Excel, and have in Module1, but it's not
running...

Sub AUTO_OPEN()
Application.ScreenUpdating = False
Sheets("Details").Select
Columns("L:L").Select
Selection.NumberFormat = "$#,##0.00_);[Red]($#,##0.00)"
Columns("M:M").Select
Selection.NumberFormat = "0"
Columns("N:N").Select
Selection.NumberFormat = "$#,##0.00_);[Red]($#,##0.00)"
Sheets("Sheet1").Select: Range("A1").Select
Application.ScreenUpdating = True
End Sub

TIA - Bob