Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BigPunchy
 
Posts: n/a
Default How do I setup a print command button in excel 2003

I want to be able to put a print command button at the bottom of my excel
sheet to print it. It is doing it in visual basic script.
Thank you
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Record a macro when you print the worksheet manually.

Then show the Forms toolbar.
Click on the button on that toolbar.
Then click on the worksheet where you want the top left corner to be and drag
down to the bottom right.

When you let go, you'll be prompted for the macro to assign to this button.

Choose the one you recorded.



BigPunchy wrote:

I want to be able to put a print command button at the bottom of my excel
sheet to print it. It is doing it in visual basic script.
Thank you


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 03:31 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 11:20 PM
Microsoft Excel could not find anything to print cyndi Excel Discussion (Misc queries) 1 December 22nd 04 02:40 PM


All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"