|
本帖最后由 hlssoft 于 2012-7-17 13:54 编辑
午餐菜谱2012-7-13.rar
(11.7 KB, 下载次数: 16)
每天要打印当天的菜谱,打印时要设置一下边框和边距,做了一个加载宏,结果不起作用,在网上看了几个帖子说是这类事件要写类模块,学着网上的帖子做了一个,仍然不起作用,代码如下:
Thisworkbook:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Call InitializeAppEvent
End Sub
模块1:
Dim myAppEvent As New AppEventCls
Sub InitializeAppEvent()
Set myAppEvent.AppEvent = Application
End Sub
类模块AppEventCls:
Public WithEvents AppEventCls As Application
Private Sub Appeventcls_WorkbookBeforePrint(ByVal Wb As Workbook, Cancel As Boolean)
If Wb.Name Like "午餐菜谱*" Then
With Wb.Worksheets("菜谱").Range("A3").CurrentRegion.Borders
.LineStyle = xlContinuous
.Weight = xlThin
End With
With Wb.Worksheets("菜谱").PageSetup
.LeftMargin = Application.InchesToPoints(0.5)
.RightMargin = Application.InchesToPoints(0.5)
.CenterHorizontally = True
End With
End If
End Sub
本人对类模块完全是菜鸟,希望高手能指点一下。
|
|