We are using windows xp and excel 2007.
we have a worksheet with command buttons and some VBA code linked to it.
we are trying to simply copy a worksheet from one tab to another. All the formatting and cell contents copy over, but the command buttons won't copy.
We are copying the sheet by right-clicking on the tab and selecting Move or Copy and copying to a new sheet in the same workbook.
we also tried with the VBA code :
This also does not work.Workbooks(CurWrkBook).Worksheets("Template").Copy after:=Sheets("Template_H")
ActiveSheet.Name = NewSheet
Note-this is only failing on one PC. All other pc's are working fine. Any ideas?
Thanks
Bookmarks