ExcelBanter - PageSetup Macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - PageSetup Macro (https://www.excelbanter.com/excel-worksheet-functions/181770-pagesetup-macro.html)

I've recorded a Page Setup Macro and placed it Personal.xls. I trigger it
after the Print Area because it varies one file to another. The problem I
have is that the macro has a Print Area already set in the macro from
recording despite not recording one. I think i need to edit the VBA but am
not sure how.

Thnaks

Sat, 29 Mar 2008 12:53:48 GMT from Julian Glass
:
I've recorded a Page Setup Macro and placed it Personal.xls. I trigger it
after the Print Area because it varies one file to another. The problem I
have is that the macro has a Print Area already set in the macro from
recording despite not recording one. I think i need to edit the VBA but am
not sure how.

Open your personal.xls and press Alt-F11.

In the explorer-style list at the left, double-click anything called
Modules or Module.

Find your code, change it, and save it.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...