Showing built in dialogue boxes
 

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

Showing built in dialogue boxes
 

Try:

Application.Dialogs(xlDialogPageSetup).Show

---
Regards,
Norman



wrote in message
...
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

Showing built in dialogue boxes
 

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

Showing built in dialogue boxes
 

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

Regards,

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