Help needed for option to print specific page

[Kenny Bell]

Hello all

My first post here.

I'm looking for something probably very simple.

I have a worksheet, name "essentials", which has 290 printable pages. I want to be able to print one page at a time from the selection of pages 1 to 290.

e.g. Assign a macro to a "print" button which will then create a pop up(?) asking which page between 1 to 290 that I want to print, then carry on to print that page.

Aplogies if this has been covered before - I have spent the better part of a day trying to track this down.

Hope this makes sense. I have very limited knowledge of VBA.

Thank you all for reading and thanks in advance for your help.

Kenny

 

[HackSlash]

The Print button in Excel does this. Why would you rewrite the print function made by Microsoft?

Press "Print"
Under "Settings"
Type the page number

It behaves just like you describe.

 

[Kenny Bell]

The Print button in Excel does this. Why would you rewrite the print function made by Microsoft?

Press "Print"
Under "Settings"
Type the page number

It behaves just like you describe.

Thank you for your constructive reply. I am, of course, aware of the print function.

I should have clarified. I work with approximately 60 colleagues. Some are not "computer literate" (for want of a better phrase). I am trying to make printing this document as easy as possible for them, thus my request.

 

[HackSlash]

I'm sorry Kenny. That sounds like an HR problem and not a software problem. Teaching them how to print a page is more valuable then teaching them how to use your custom code that you wrote. The ability to print a page will be useful across many spreadsheets and applications.

I would write a work instruction called "How to print a page". Take some screen shots and write it up. It seems absurd but then you can have something to laugh about.

Something like this:
3 Ways to Print Part of an Excel Spreadsheet - wikiHow

 

[Kenny Bell]

Hi HackSlash

Thanks again for your reply.

Completely agree it's an HR problem. It's unfortunate you don't know the people I work with or you'd know where I'm coming from!