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?