print button

C

Caveman

I have a spresdsheet of 5 pages. I only want to print certai
highlighted columns,(always the same ones). can i put a button with
macro to print them off when i want them without highkighting them al
every time???
 
D

dominicb

Good morning caveman

You can do this yourself, and learn about macros to boot.

Tools > Macros > Record new macro

Then hide the columns, print the reoprt and then unhide the columns.
When you have done click on the stop button. Then right click over the
menu bar and select the Forms toolbar. Using the button tool draw a
button and then assign a macro to it (it will probably be called
macro1).

Voila! A macro that can be called whenever you please!

HTH

DominicB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top