Showing built in dialogue boxes

[Guest]

Hi All,

How can I show Excel's built in dialogue boxes e.g. Page
Set Up with a macro. For example, if the user clicks a
custom button embeded on a sheet, the dialogue box for
page set up will appear?

Thanks in advance

 

[Norman Jones]

Try:

Application.Dialogs(xlDialogPageSetup).Show

 

[Jan Karel Pieterse]

How can I show Excel's built in dialogue boxes e.g. Page

Set Up with a macro. For example, if the user clicks a
custom button embeded on a sheet, the dialogue box for
page set up will appear?

Application.Dialogsheets(....).Show
You'll get a list of possible dialogs from intellisense once you type
the first (

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Jan Karel Pieterse]

Oops, that should've been Dialogs, not Dialogsheets.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com