Do you just want to show the pagesetup dialog box?

Application.Dialogs(xlDialogPageSetup).Show

" wrote:

Hello,

I am trying to create a macro button to help me automatically do the
following tasks:

-Change Sheet
-View
-Header and Footer
-Custom Header

When I try to record the macro, it won't let me stop the macro with a
dialog box open.

The custom header will change every time the file is opened.

Any ideas?

Any help is greatly appreciated!

Matt St.Onge
Drafting & Estimating Manager
Mankato Kasota Stone
www.mankatokasotastone.com