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

Is running, but NOT working..Also, placing AUTO_OPEN there does NOT
run..tested both Workbook_Open and AUTO_OPEN using "Stop"..

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Sheets("Details").Select
Columns("I:I").Select
Selection.NumberFormat = "m/d/yy;@"
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("Monthly Reconcile Report").Select: Range("A1").Select
Application.ScreenUpdating = True
End Sub

Ideas? TIA - Bob