View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default button to print a sheet

"asking a macro" s/b "assign a macro"

--


Gary


"Gary Keramidas" wrote in message
...
have you tried recording a macro while you print what you want to?

tools/macro/record new macro

then print your sheet.
stop recording

then click on view/toolbars
select forms
click the command button
draw it where you want it on the sheet.
a dialog will pop up asking you to asking a macro
choose the one you just recorded
click ok
type the name of the button where it says button 1
close the toolbar and you should have a button with a macro assigned to it

--


Gary


"cid" wrote in message
...

Hi
I need help again..
ps thankx robin for helping out last time..
new question
I need to make a macro button that prints out a certain sheet...
I have been trying to make one, but I am hopeless.
cheers
cid


--
cid
------------------------------------------------------------------------
cid's Profile:
http://www.excelforum.com/member.php...o&userid=25582
View this thread:
http://www.excelforum.com/showthread...hreadid=390086