View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
luvthavodka luvthavodka is offline
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"?