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
Last edited by Storm08; 01-26-2012 at 06:31 AM.
will achieve option one.ActiveSheet.Copy
Good luck.
Cheers for the reply, i have solved it myself... dunno how cause im rubbish with vba but here it is:
Sub Save_Click() Application.ScreenUpdating = False ActiveSheet.Select ActiveSheet.Copy ThisFile = Range("B1,AB322").Value Application.ScreenUpdating = True End Sub
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.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks