Macros that can open an open menu

R_PARASKEVAS · Apr 9th, 2002, 03:32 AM

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

Dave Hawley · Apr 9th, 2002, 03:38 AM

Hi R_PARASKEVAS

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

R_PARASKEVAS · Apr 12th, 2002, 03:25 AM

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 · Apr 13th, 2002, 06:50 PM

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.

Apr 13th, 2002, 06:50 PM	#4
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	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. __________________ <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;">*DALEY :P**</td></table>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 03:32 AM	#1
R_PARASKEVAS New Member Join Date: Apr 2002 Location: Ricki Posts: 2	How can i get a macro to open the open menu?

Apr 9th, 2002, 03:38 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi R_PARASKEVAS Yes, see here: http://www.ozgrid.com/VBA/ExcelsDialogBoxes.htm

Apr 12th, 2002, 03:25 AM	#3
R_PARASKEVAS New Member Join Date: Apr 2002 Location: Ricki Posts: 2	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?