LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Basic Macro Query

This is my first time trying to write a Macro, but it doesn't seem to work!

I want a "button" on sheet 1 (which is currently just cell D2). On clicking
this button the entire workbook will be printed, except for sheet 1.

So far I have created this code:

Sub Print_All()
'
' Print_All Macro
' Macro recorded 03/01/2007 by Jenny
'

'
Range("D2").Select
ActiveWorkbook.PrintOut Copies:=1, Collate:=True
End Sub

On selecting run macro, this seems to work (although prints sheet 1 also
which I don't want). Nothing happens however when D2 is selected - how do I
make this look like a "button"?

 
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
Macro Help (Uppercase multiple ranges?) Ken Excel Discussion (Misc queries) 14 December 2nd 06 07:23 PM
Visual basic macro move cursor down 1 cell Roger Excel Worksheet Functions 1 September 12th 06 08:09 PM
how do I email amacro? leo Excel Worksheet Functions 24 August 9th 06 02:47 PM
Formula Help Robert Excel Worksheet Functions 15 January 3rd 06 02:17 AM
How do I run a Macro on basic of a value in a specific cell Steen H. Pedersen Excel Worksheet Functions 3 April 16th 05 08:52 AM


All times are GMT +1. The time now is 07:24 PM.

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

About Us

"It's about Microsoft Excel"