ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel's camera tool (https://www.excelbanter.com/excel-discussion-misc-queries/131508-excels-camera-tool.html)

Camera Shy

Excel's camera tool
 
When the range of a picture taken by Excel's camera tool is hidden, the
picture disappears. Is there a way to show the picutre even when the range
is hidden?

Dave Peterson

Excel's camera tool
 
Can you make it a static picture--not a picture link?

Select the range
edit|copy
go to where you want the picture
shift-edit|Paste picture



Camera Shy wrote:

When the range of a picture taken by Excel's camera tool is hidden, the
picture disappears. Is there a way to show the picutre even when the range
is hidden?


--

Dave Peterson

Camera Shy[_2_]

Excel's camera tool
 
The picture must be dynamic (linked to the source).

"Camera Shy" wrote:

When the range of a picture taken by Excel's camera tool is hidden, the
picture disappears. Is there a way to show the picutre even when the range
is hidden?


Dave Peterson

Excel's camera tool
 
The don't hide the range????

Camera Shy wrote:

The picture must be dynamic (linked to the source).

"Camera Shy" wrote:

When the range of a picture taken by Excel's camera tool is hidden, the
picture disappears. Is there a way to show the picutre even when the range
is hidden?


--

Dave Peterson

suni_NZ

Excel's camera tool
 
Instead of hiding the range, if it is at the edge of a sheet, you can use
freeze panes and scroll the part that you don't want seen out of view

"Camera Shy" wrote:

When the range of a picture taken by Excel's camera tool is hidden, the
picture disappears. Is there a way to show the picutre even when the range
is hidden?



All times are GMT +1. The time now is 03:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com