Showing built in dialogue boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
Click to expand...

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
 
Back
Top