I need to be able to create a macro that will record what printer settings i
set when i go to print... I have tried and it will not record it.

Does anyone know how to do this?

I know I can set my defaults in control panel but it does not seem to stay
and I do not know why either.

Help please!

before you record your macro, be sure the printer you want to select, is
not already selected, then when you record the macro, you will then
select the one you want and there fore, your selection will get
recorded.


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326

Hey Dave.. thanks for the reply.. i got it to do that... its the part where I
need it to record the settings I set for the printer that it does not do.

Any ideas?

"davesexcel" wrote:


before you record your macro, be sure the printer you want to select, is
not already selected, then when you record the macro, you will then
select the one you want and there fore, your selection will get
recorded.


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326

let me be a bit more specific... its recording the settings i change for the
pdf writer printer.... doesnt seem to record it

"Scooby" wrote:

Hey Dave.. thanks for the reply.. i got it to do that... its the part where I
need it to record the settings I set for the printer that it does not do.

Any ideas?

"davesexcel" wrote:


before you record your macro, be sure the printer you want to select, is
not already selected, then when you record the macro, you will then
select the one you want and there fore, your selection will get
recorded.


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326

I am curious, do the settings record when you select a different
printer???


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326

No it does not seem to. I attempted to simply change from portrait to
landscape on my regular laser printer and still did not record it.

We were able to keep the settings in Control Panel so that the fonts would
not send to pdf but still need the macro to make it print to pdf correctly.

"davesexcel" wrote:


I am curious, do the settings record when you select a different
printer???


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326