macro question

nancyo · Mar 28th, 2002, 12:41 PM

I have a very simple macro which includes as part of the code entering page setup (print preview) and deleting the footer (the other spreadsheets have an automatic footer when the file is opened).

Everything works fine except the macro stops on the print preview screen. When I recorded the macro, the keystrokes included closing the print preview and selecting cell A1???

Juan Pablo González · Mar 28th, 2002, 12:44 PM

You don't need to enter Print Preview to do that. You can get the same result using Page Setup from the File menu.

nancyo · Mar 28th, 2002, 01:12 PM

I re-recorded the macro as suggested, worked fine. THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Mar 28th, 2002, 12:44 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	You don't need to enter Print Preview to do that. You can get the same result using Page Setup from the File menu. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 12:41 PM	#1
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	I have a very simple macro which includes as part of the code entering page setup (print preview) and deleting the footer (the other spreadsheets have an automatic footer when the file is opened). Everything works fine except the macro stops on the print preview screen. When I recorded the macro, the keystrokes included closing the print preview and selecting cell A1???

Mar 28th, 2002, 01:12 PM	#3
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	I re-recorded the macro as suggested, worked fine. THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!