Hyperlink

[kalooriprasad]

Dear Sir/Madam,

How Can give a print with using of hyperlink,

An Excel How can i Give a print with clicking the one button.


Regards,

Shiva prasad

 

[Hui]

You can have a simple macro linked to a Button on your sheet

Insert a Button or Shape

Copy the following macro into a code module in VBA

Right Click the Button and assign the macro

The macro will assume all current print settings and predefined print area and default printer

[pre]

Sub PrintMe()
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False
End Sub

[/pre]

Or you could just add a Quick Print Button to the Quick Access Toolbar