+ Reply to Thread
Results 1 to 5 of 5

Saving a worksheet without the page code

  1. 05-21-2012, 11:29 AM #1
    BrianSells
    BrianSells is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Sevierville, tn
    MS-Off Ver
    Office 2010 Professional
    Posts
    46

    Saving a worksheet without the page code

    I have a multiple page workbook that my customers order from. I have a worksheet that pulls data from another sheet with code. I am trying to make a button on a userform save the one sheet to another workbook. I really need to keep the activation code on this sheet, but when I try to save this, it's trying to run the page code. This is giving me an out of range error because the other sheets are not in the new workbook. Is there a way to save this sheet without the code? I have tried several things, including putting the code for the sheet into the button, but I just can't get it. Thanks in advance for any help!
    Reply With QuoteRegister To Reply
  2. 05-21-2012, 12:14 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Saving a worksheet without the page code

    Hello BrianSells,

    It would be best if you post the workbook rather than spend a lot of time asking and answering questions about the code.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 05-21-2012, 12:35 PM #3
    BrianSells
    BrianSells is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Sevierville, tn
    MS-Off Ver
    Office 2010 Professional
    Posts
    46

    Re: Saving a worksheet without the page code

    My bad, I intended to attach this originally and got distracted. The sheet "Pick List" is the one I need to save separately from the rest of the workbook. Thanks again for the help.

    Test Order.xlsm
    Last edited by Leith Ross; 05-21-2012 at 12:50 PM.
    Reply With QuoteRegister To Reply
  4. 05-21-2012, 01:29 PM #4
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Saving a worksheet without the page code

    Hello BrianSells,

    Here is the macro to create a new workbook with the "Pick List" copied over without the macros.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-21-2012, 02:03 PM #5
    BrianSells
    BrianSells is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Sevierville, tn
    MS-Off Ver
    Office 2010 Professional
    Posts
    46

    Re: Saving a worksheet without the page code

    Perfect! Thanks a bunch, this has been driving me crazy! That does exactly what I've been trying to do!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1