Saving One Sheet In New Workbook

Hi all

The user needs to be able to click a button and save the active sheet in a new workbook. Whether this copies the sheet to a new workbook and then the user can save in a normal way, or the user clicks the button it comes up with a save dialogue box and the user can choose where to save it in the normal way from the original sheet.

Sorry if the question isnt clear, if you need clarification then just say

Thanks,
Storm08

Please Login or Register  to view this content.

will achieve option one.

The first two lines and the last are unnecessary, and the line relating to ThisFile has nothing to do with anything you mentioned in the question. Which leaves you with the line I suggested.