Modify recording Macro

[josros]

Hi,

I recorded the code below using create/export multiple sheets in one pdf file.

How to modify it to:

1. Prompt to select sheets
2. for location and file name

here the code:

Please Login or Register  to view this content.

Thank you,

[ByteMarks]

I think prompting for the sheets would be more involved. Instead this takes the selected sheets and prompts to pdf them.
Not sure what you wanted to do about the filename, so I left it as it was before.

Please Login or Register  to view this content.

[josros]

Thank you so much, worked perfectly.

Just one thing about file name, would like to give a name myself. Like "backup invoice # 000 something like that.

[ByteMarks]

In that case I would use GetSaveAsFilename

Please Login or Register  to view this content.

[josros]

Thank you so much for your help.

Worked.

[ByteMarks]

You're welcome.