Printing 6 copies
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Printing 6 copies

  1. #1
    Guest

    Default

     
    We have a couple of old spreadsheets that is set to print 6 copies every time they open. If we change the # of copies back to 1 and save, it reverts back to 6 when it is reopened. Major pain as it's a pretty long sheet. We have attempted to copy the whole thing to a new sheet, but this doesn't work.

    Any ideas appreciated.

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you looked in the Auto_Open macro - I guess you have but worth a try!

    John

  3. #3
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You've changed the ("auto_open") macro in the visual basic editor, saved the file and it reverts back?

    Maybe the macro's in your personal.xls file, when you're saving the file, you're not saving the updated macro.

    Sounds odd. Nate

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    Sounds like a scripts is hiding ... assign a command button to any script to bring up all scripts and look for one related,

    Sounds like personal or auto open but could be in the shhet its self of cause and might be called from elsewhere, should be able to find it and so can edit back to on or switch off if needs be.

    Open VBE and scan the moduels and sheets might be worth a try.

    HTH
    Rdgs
    ==========
    Jack

  5. #5
    Guest

    Default

      
    Fixed it in the Scripts--new to me! Thanks all.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com