Excel / Create a "Print This Page" Button
Benjamin
-
Mavi -
Mavi -
Hello,
Is there a solution to create a "button" that users can click to print the corresponding page?
In my opinion, there seems to be some "macro" involved... I know ABSOLUTELY NOTHING about it, so if anyone has a "ready-to-use" solution, I am all ears.
Thanks in advance.
Is there a solution to create a "button" that users can click to print the corresponding page?
In my opinion, there seems to be some "macro" involved... I know ABSOLUTELY NOTHING about it, so if anyone has a "ready-to-use" solution, I am all ears.
Thanks in advance.
Configuration: Windows XP Internet Explorer 6.0
5 réponses
Hi,
it's true that you need to create a macro but this can be made very easy with the recording of actions without going through the programming of code.
To do this, go to Tools --> Macro --> Record a Macro.
As soon as you start recording (as soon as the "Stop Recording" window appears)
you perform the following actions:
File --> Print --> Print Area: Selection --> OK
Then:
you click on the "Stop Recording" window and name it "Print"
Finally:
Tools --> Customize --> (Toolbar tab) Add
you add the "Print" function that you will find in your macros.
And now in your toolbar, you have a "Print" command that corresponds to printing the current page.
This corresponds to what you are asking for.
Otherwise, you can always record all the actions you want and make a button in the toolbar using the same method.
That's it,
Good luck
--
science without conscience is just the ruin of the soul!
it's true that you need to create a macro but this can be made very easy with the recording of actions without going through the programming of code.
To do this, go to Tools --> Macro --> Record a Macro.
As soon as you start recording (as soon as the "Stop Recording" window appears)
you perform the following actions:
File --> Print --> Print Area: Selection --> OK
Then:
you click on the "Stop Recording" window and name it "Print"
Finally:
Tools --> Customize --> (Toolbar tab) Add
you add the "Print" function that you will find in your macros.
And now in your toolbar, you have a "Print" command that corresponds to printing the current page.
This corresponds to what you are asking for.
Otherwise, you can always record all the actions you want and make a button in the toolbar using the same method.
That's it,
Good luck
--
science without conscience is just the ruin of the soul!
you are a genius