Macro for Project Gallery in Excel

[john.e.palmer]

Word has a keystroke shortcut for Project Gallery, but Excel does
not. Is it possible to write an Excel macro that would open the
project gallery (and list Excel files only if that is possible) and
then either terminate macro at that point or wait until a file is
selected and then terminate?

Thanks.

 

[JE McGimpsey]

Word has a keystroke shortcut for Project Gallery, but Excel does
not. Is it possible to write an Excel macro that would open the
project gallery (and list Excel files only if that is possible) and
then either terminate macro at that point or wait until a file is
selected and then terminate?

MacXL has the same default keystroke shortcut for the Project Gallery as
Word does - CMD-SHIFT-p. You can, of course, set it to anything you want
with Tools/Customize/Customize Keyboard...

The Project Gallery isn't scriptable (except that in both Word and XL
you can set the Application.StartupDocument property to determine
whether the Project Gallery is displayed when the app starts). So you
can't change the display preferences set in the Customize Pane, but you
can specify *both* Word Documents and Excel Workbook in that pane. Any
change to that dialog will apply to all Office apps.

 

[john.e.palmer]

MacXL has the same default keystroke shortcut for the Project Gallery as
Word does - CMD-SHIFT-p. You can, of course, set it to anything you want
with Tools/Customize/Customize Keyboard...

The Project Gallery isn't scriptable (except that in both Word and XL
you can set the Application.StartupDocument property to determine
whether the Project Gallery is displayed when the app starts). So you
can't change the display preferences set in the Customize Pane, but you
can specify *both* Word Documents and Excel Workbook in that pane. Any
change to that dialog will apply to all Office apps.

(1) Thanks!
(2) CMD-SHIFT-P brought up the pivot table wizard, but I got rid of it
in the customize keyboard section and now CMD-SHIFT-P does bring up
the Project Gallery.