• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

Printing Active Worksheet using VBA

Hi Team,
I have design a dashboard like worksheet Tab. Here I have many fields ike dropdown, textbox and comment field. out of these only comment field is dynamic i.e. its size does change automatically as input goes.
I need a print functionality so that I could print this.
Can you please suggest how could I print this dynamic Tab using VBA.
Also require if print goes beyond one page because of long input comments I might require footer as well.
Looking forward to hearing from you.
  • 3
1 Solution
satmishaAuthor Commented:
Footer like 1 of 3 Page.
Robberbaron (robr)Commented:
a bit hard to start without example...
is this a worksheet tab or a form ?

can you start the macro recorder, print the 'tab' manually, then stop the macro recorder.  Please Post the resulting code.
(macro recorder is on developer tab that you have to enable in Options)
satmishaAuthor Commented:
Thanks lot Robber and I also do agree with you. This is simple worksheet Tab.
satmishaAuthor Commented:
Thanks expert.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now