ram117
11-10-2005, 01:26 AM
Hi Everybody,:hi:
I have three worksheets nowI need a VBA Code(macro) such that it will copy the third worksheet and to save as a new worksheet. When the code runs Save as dialogbox should appear to save the third sheet.(It is like when we right click on third sheet tab it popus a menu in which we have move or copy to location) for the same thing I need a macro but save as dialog box should appear. Any suggestions pl. tell me.:dunno
Thanks and Regards
Ram
I have three worksheets nowI need a VBA Code(macro) such that it will copy the third worksheet and to save as a new worksheet. When the code runs Save as dialogbox should appear to save the third sheet.(It is like when we right click on third sheet tab it popus a menu in which we have move or copy to location) for the same thing I need a macro but save as dialog box should appear. Any suggestions pl. tell me.:dunno
Thanks and Regards
Ram