Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint
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 If wk.Name = "DATA - ALL" Then Range("F12").ColumnWidth = 100 End If Next End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint
Works for me. Did you setup application events correctly?
-- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Robin Clay" wrote in message ... 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 If wk.Name = "DATA - ALL" Then Range("F12").ColumnWidth = 100 End If Next End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint
"Bob Phillips" wrote:
....for which, muchos gracias. Works for me. Did you setup application events correctly? Huh ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint
"Bob Phillips" wrote:
From your response, you don't need them so use Thank you ! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint
"Tom Ogilvy" wrote:
Use the Workbook level BeforePrint Thank you ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BeforePrint help | Excel Programming | |||
BeforePrint macro | Excel Discussion (Misc queries) | |||
BeforePrint Add In | Excel Programming | |||
ADO 2.7 & ADO 2.8 beforeprint | Excel Programming | |||
Help with BeforePrint | Excel Programming |