Printing 6 copies

[Guest]

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.

 

[bobeuk]

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

John

 

[NateO]

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

 

[Jack in the UK]

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

 

[Guest]

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