sorry i am again, after run this macro my data gone ! how can get back ?
"CLR" wrote:
> The macro should be placed in the "This Workbook" module, and it will run
> automatically when a user tries to print.
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Tufail" wrote:
>
> > i made this macro now pls tell me how i can run ?
> >
> > "CLR" wrote:
> >
> > > Excel "security" is usually easily circumvented, but something along these
> > > lines might do what you want.........
> > >
> > > Private Sub Workbook_BeforePrint(Cancel As Boolean)
> > > Range("B5:E10").Select
> > > Selection.ClearContents
> > > Range("A1").Select
> > > End Sub
> > >
> > > hth
> > > Vaya con Dios,
> > > Chuck, CABGx3
> > >
> > >
> > >
> > > "Tufail" wrote:
> > >
> > > > hello, how can i stop someone to make printout my sheet or some data
> > > > thanks in advance
Bookmarks