Printing 6 copies

Feb 19th, 2002, 12:43 PM

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 · Feb 19th, 2002, 01:02 PM

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

John

NateO · Feb 19th, 2002, 01:03 PM

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 · Feb 19th, 2002, 05:53 PM

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

Feb 21st, 2002, 09:16 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 12:43 PM	#1
Guest Posts: n/a	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.

Feb 19th, 2002, 01:02 PM	#2
bobeuk New Member Join Date: Feb 2002 Posts: 10	Have you looked in the Auto_Open macro - I guess you have but worth a try! John

Feb 19th, 2002, 01:03 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	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

Feb 19th, 2002, 05:53 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	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

Feb 21st, 2002, 09:16 AM	#5
Guest Posts: n/a	Fixed it in the Scripts--new to me! Thanks all.