+ Reply to Thread
Results 1 to 2 of 2

Command buttons won't copy

  1. #1
    Registered User
    Join Date
    11-18-2010
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2007
    Posts
    1

    Command buttons won't copy

    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 :
    Workbooks(CurWrkBook).Worksheets("Template").Copy after:=Sheets("Template_H")
    ActiveSheet.Name = NewSheet
    This also does not work.
    Note-this is only failing on one PC. All other pc's are working fine. Any ideas?
    Thanks
    Last edited by laureatehelp; 11-22-2010 at 12:22 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Command buttons won't copy

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1