oryan_dunn


I'm writing a macro that will, as part of its operation, update all fields within the document. I need all my custom fields filled out prior to running this macro. I'd like to be able to prompt the user to fill out the properties by providing a button that will open directly to the Custom tab of the file properties dialog box. How do I go about programming this

Thanks,

Ryan




Re: How to open "Properties" dialog box to "Custom" tab within macro?

Andy Pope


Hi,

This will display the properties dialog. Not sure you will be able to control whether the Custom tab has focus on showing it.

Application.Dialogs(xlDialogProperties).Show







Re: How to open "Properties" dialog box to "Custom" tab within macro?

oryan_dunn

Thanks for the reply. It looks like that is an excel dialog box. I should have specified that I'm working with a Word document as that code doesn't work. Any other suggestions

Thanks,

Ryan