Hi everyone,
I have an Excel 2013 workbook that I use a click button with VBA to copy and save the tab to a new workbook and it copies only the values as it should but...it also copies the button that is used in the original tab and keeps the link to that VBA. I would like to eliminate that button and link automatically within the original VBA. Is it possible to add something to this VBA or modify it so that the button with the VBA on the original page does not copy to the new workbook or at least remove the link to the VBA? Removing the button automatically would be nice but just removing the link automatically would be good enough. I am kinda new to this.
This is the VBA that I use to copy the tab to the new workbook by clicking the button on the original page:
Sub SaveCopy()
ActiveSheet.Copy
Set newbk = ActiveWorkbook
newbk.ActiveSheet.Cells.Copy
newbk.ActiveSheet.Cells.PasteSpecial Paste:=xlPasteValues
InitialName = Format(Date, "mm-dd-yy") & ".xlsx"
FName = Application.GetSaveAsFilename(InitialFileName:=InitialName, _
fileFilter:="Excel Files (*.xlsx), *.xlsx")
newbk.SaveAs Filename:=FName
Range("E2").Select
End Sub
Thanks for any help,
Foos Master
"Foosball is Therapy"
Bookmarks