Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
print screen
Hi, I need a screenshot of my desktop triggered by exel. something like: if Range("a1").Value = 1 then PRINTSCREEN Can it be done? Thanks -- climax ------------------------------------------------------------------------ climax's Profile: http://www.excelforum.com/member.php...o&userid=30816 View this thread: http://www.excelforum.com/showthread...hreadid=516576 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
print screen
Enter this code in the sheet object (not a regular module)
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim WatchRange As Range Set WatchRange = Range("A1") If Range("A1").Value = 1 Then ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End If End Sub "climax" wrote: Hi, I need a screenshot of my desktop triggered by exel. something like: if Range("a1").Value = 1 then PRINTSCREEN Can it be done? Thanks -- climax ------------------------------------------------------------------------ climax's Profile: http://www.excelforum.com/member.php...o&userid=30816 View this thread: http://www.excelforum.com/showthread...hreadid=516576 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
print screen
Correction to previous reply:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim WatchRange As Range Set WatchRange = Range("A1") If Union(Target, WatchRange).AddressLocal = WatchRange.Address Then If Range("A1").Value = 1 Then ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End If End If End Sub "climax" wrote: Hi, I need a screenshot of my desktop triggered by exel. something like: if Range("a1").Value = 1 then PRINTSCREEN Can it be done? Thanks -- climax ------------------------------------------------------------------------ climax's Profile: http://www.excelforum.com/member.php...o&userid=30816 View this thread: http://www.excelforum.com/showthread...hreadid=516576 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
print screen
I need a code that does the same as when I press the print screen button. It has to take a picture of my whole desktop and copy it to the clipboard. I need to see some results on other programs that are running together with exel. Thanks Johan -- climax ------------------------------------------------------------------------ climax's Profile: http://www.excelforum.com/member.php...o&userid=30816 View this thread: http://www.excelforum.com/showthread...hreadid=516576 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
print screen
Go to download.com and find screen capture programs. I use one called Screenprint32. Snagit is another good one. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=516576 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a pasted screen print to appear? | Excel Discussion (Misc queries) | |||
Words wrapped differently on screen and on print preview | Excel Discussion (Misc queries) | |||
In Excel 2003 Is it possible to print a split screen in a spreadsh | Excel Discussion (Misc queries) | |||
Print and Print Preview don't match screen | Excel Worksheet Functions | |||
Difference between screen view and print | Excel Discussion (Misc queries) |