| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Debug issue with macros
I have an xls with a macros to insert the file path into
the footer just prior to printing. However, whenever someone else tries to do a print preview on that file the debugger pops up. Here is the macros as it appears in my xls: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = ThisWorkbook.FullName End Sub Whats the deal? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Debug issue with macros
I just tested with xl2002 and it worked without intervention.
-- Don Guillett SalesAid Software "Jess" wrote in message ... I have an xls with a macros to insert the file path into the footer just prior to printing. However, whenever someone else tries to do a print preview on that file the debugger pops up. Here is the macros as it appears in my xls: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = ThisWorkbook.FullName End Sub Whats the deal? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Debug Issue | Excel Discussion (Misc queries) | |||
| Macros Issue | Excel Discussion (Misc queries) | |||
| VB macros issue with selecting cells on different page | Excel Discussion (Misc queries) | |||
| DeBug | Excel Discussion (Misc queries) | |||
| Debug/Compile: Compilng excel macros? What it generates? | Excel Programming | |||
Linear Mode
