Re: Debug issue with macros

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Don Guillett (donaldb_at_281.com)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 09:54:11 -0500

I just tested with xl2002 and it worked without intervention. 

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"Jess" <anonymous@discussions.microsoft.com> wrote in message
news:202e101c4592d$d4b8d5a0$a301280a@phx.gbl...
> 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)
>    Active***.PageSetup.LeftFooter = ThisWorkbook.FullName
> End Sub
>
> Whats the deal?
Quantcast