Header / Footer Dialog (XL XP)

Topic

New Reply

I was trying to activate the header footer dialog via vba using (something like) the following

	Application.Dialogs(xlDialogPrinterSetup).Show

but I don’t know the xlDialog… key word.

Reply | Quote

Replies

Use Application.Dialogs(xlDialogPageSetup).Show to display the page setup dialog. From this, you can open the custom header/footer dialog.

Reply | Quote

Thx Hans – I was hoping to go straight to the header / footer dialog and not via the pagesetup – oh well, guess I cannot do that.

Reply | Quote