Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I link to a print command from a cell?
I have a spreadsheet in which I have incorporated hyperlinks to access other
pages and cells. Is it possible to program a hyperlinked cell to cause a particular worksheet to print without having to go to the print command on the menu bar? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I link to a print command from a cell?
Yes, put your code in the FollowHyperlink event of the worksheet. For
example, this will print the active sheet if the hyperlink in A1 is clicked. Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) If Target.Range.Address = "$A$1" Then ActiveSheet.PrintOut End Sub "tcloud@lcc" wrote: I have a spreadsheet in which I have incorporated hyperlinks to access other pages and cells. Is it possible to program a hyperlinked cell to cause a particular worksheet to print without having to go to the print command on the menu bar? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Print # command print not all rows from excel sheet to file | Excel Programming | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
How to create a link by using command button in VB | Excel Discussion (Misc queries) | |||
Change Print Command or add a new print command | Excel Programming | |||
command for breaking link in excel is not seen. | Excel Discussion (Misc queries) |