Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before_Print
Greetings !
Would anyone have some idea why this don't work - please ? Private Sub App_WorkbookBeforePrint(ByVal Wb As Workbook, Cancel As Boolean) For Each wk In Wb.Worksheets wk.Calculate If wk.Name = "DATA - ALL" Then Range("F12").ColumnWidth = 100 End If Next End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before_Print
Try this
Private Sub Workbook_BeforePrint(Cancel As Boolean) Application.Calculation = xlCalculationAutomatic Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets If wks.Name = "DATA - ALL" Then Range("F12").ColumnWidth = 100 End If Next wks End Sub "Robin Clay" wrote: Greetings ! Would anyone have some idea why this don't work - please ? Private Sub App_WorkbookBeforePrint(ByVal Wb As Workbook, Cancel As Boolean) For Each wk In Wb.Worksheets wk.Calculate If wk.Name = "DATA - ALL" Then Range("F12").ColumnWidth = 100 End If Next End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Before_Print
"Mike" wrote:
Try this Thank you for your response - but it wasn't the "calculate" that was the problem, it was the "column width". My fault, sorry ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
before_print does not work - f8 key does not do anything | Excel Programming | |||
Before_Print | Excel Programming | |||
Re-Post: Before_Print Sub Doesn't Trigger | Excel Programming |