MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Why Excel refused to record my Macro?

  Asked By: Anpu    Date: Sep 29    Category: MS Office    Views: 1126

I want to print my stuff on both pages of the paper. I changed the
settings in the command menu. I recoreded the whole process but then
when I opened the code window, I noticed that the macro didn't
record it at all!!!

How to solve the problem? Why this can happen?



5 Answers Found

Answer #1    Answered By: Lena Moore     Answered On: Sep 29

I don't know where you changed  your settings and what you saw after stopping the
recorder. Did you see something like:
sub macro1()

end sub

or nothing at all? There are certain commands which the macro  recorder does not
record at all. When you change the toolbars for example, this process  is not
recorded. All you get in this case is an empty macro as shown above.

Answer #2    Answered By: Kathleen Adams     Answered On: Sep 29

No, I did see sub macro1().

The problem is, the code  won't reflect the changes I made with
printer properties.

Looks like VBA can't directly control printer. I don't know how to
play with printer server to get the settings changes so that duplex
printing can be default setting.

You got what I'm saying now?

Answer #3    Answered By: Dixie Jacobs     Answered On: Sep 29

The usual work around is to make a second printer definition where the
default attribute is double sided. This is down outside of Excel. Go to the
Control panel, select printers and add a new printer. You can have multiple
printer definitions pointing to the same printer. Of course, choose an
appropriate name for the printer "Laserjet 1012 DoubleSided".

Within Excel, change the printer attributes by selecting a different

Answer #4    Answered By: Saiqa Mian     Answered On: Sep 29

"down outside Excel" should be "done outside Excel"

Answer #5    Answered By: Fareess Khan     Answered On: Sep 29

It saves me from reading a mountain of printer
manual books.

Didn't find what you were looking for? Find more on Why Excel refused to record my Macro? Or get search suggestion and latest updates.