Macros that can open an open menu

[R_PARASKEVAS]

How can i get a macro to open the open menu?

 

[Dave Hawley]

Hi R_PARASKEVAS

Yes, see here:
http://www.ozgrid.com/VBA/ExcelsDialogBoxes.htm

 

[R_PARASKEVAS]

Thank you for the quick reply.

Another problem -

I need my macro to open a template on a new worksheet, and to rename that worksheet. can u help?

 

[daleyman]

is the template a worksheet in the same book, ie. a hidden one,

or do you want to open a previously saved workbook, save it as something new and then change the sheet name...

both possible if you can clarify...

tx.