I have a library of little macros in one xl workbook and want to run
them on a newly received workbook . I have a menu to activate the
routines whild the new book is active.
Most of the VBA instructions work fine on the new worksheet e.g.
Range("A1").Select
ActiveCell.FormulaR1C1 = "=NOW()"
However Page Setup commands seem to be affecting my Macro library
worksheet rather than the new workbook. for example
With ActiveSheet.PageSetup
..PaperSize = xlPaperA4
..BlackAndWhite = False
..Zoom = 70
End With

Is this a bug or can I work around it?

Thanks Sandy

I just tried this (xl2003) and it worked on the activesheet--which wasn't in the
workbook with the macro.

Was that the extent of the macro?



wrote:

I have a library of little macros in one xl workbook and want to run
them on a newly received workbook . I have a menu to activate the
routines whild the new book is active.
Most of the VBA instructions work fine on the new worksheet e.g.
Range("A1").Select
ActiveCell.FormulaR1C1 = "=NOW()"
However Page Setup commands seem to be affecting my Macro library
worksheet rather than the new workbook. for example
With ActiveSheet.PageSetup
.PaperSize = xlPaperA4
.BlackAndWhite = False
.Zoom = 70
End With

Is this a bug or can I work around it?

Thanks Sandy

--

Dave Peterson