Announcement

Collapse
No announcement yet.

Insert Print Button with custom print options

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Insert Print Button with custom print options



    I am searching for a way to have one cell on my results page to be clicked so that it will print the data in the way I have customized it to print. Such as only printing certain cells, landscape, Black & White, and centered on the page.

    I have read the thread in the FAQ sub forum and see how I can set those options up myself, but for the people that will be using this tool I wanted a quick click button that takes the hassel of that out of it for them.

    Thanks

  • #2
    Re: Insert Print Button with custom print options

    You need a button from the Controls or Form Menus.

    have you got code yet? If not use the Mcro recorder whilst setting your options.
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

    Comment


    • #3


      Re: Insert Print Button with custom print options

      Thanks again. That worked perfect. I created a graphic print button and linked it to a macro I recorded as you said. It was much easier than I thought it would be. I have learned a lot about Excel this past 2 months. Quite a nifty program.

      Comment

      Working...
      X