MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Report Manager


Posted by jenniferjuniper on August 11, 2000 9:25 AM

I haven't seen much info on the Report Manager
anyplace. Is therea way to invoke it thru code?
Can it "print preview?" Thanks


Posted by JJ on August 12, 0100 12:18 PM

Celia! It worked! Thanks a gazillion, I had never
used custom view before, and have learned
something incredible!!!! Thank you!


Posted by Celia on August 11, 0100 7:24 PM

JJ
This may or may not produce what you need but try setting some Custom Views and then use the macro recorder to find the code for what you want to do. I think it is something like this :-

ActiveWorkbook.CustomViews("NameOf View").Show
ActiveWindow.SelectedSheets.PrintPreview

Celia