Take a look at the GetSaveAsFileName method in VBA Help.

In article ,
Shazza wrote:

Hi i am trying to record a macro to create a new worksheet and then save it
as the title of that worksheet but i cant get the macro to pause or wait for
me to enter in the file name and it just keeps trying to give the sheet the
same name that i saved it to when i was recording it. Is there a way of
getting it to pause so thta i can enter in the file name before it continues
with the rest of its instructions