Click Through Picture

Question

Is it still possible to click through a picture similar to what is described here?

http://spreadsheetpage.com/index.php/oddity/the_camera_tool/

It worked up through 2003.

Answer 1

Nice to see you are still here. The camera part is easy. The click through functionallity seems to be gone. When you save as 95 xl puts the workbook in compatability mode. At this point in 2003 you would normally have been able to click through but no so in compatability mode. Converting to xlsx does not bring about the click through functionallity. Near as I can tell there is no way to mouse click on a cell or cells in behind the picture.

Answer 2

I use it to allow for a default date. By default it shows the most current date in a dataset which is what people want to see 99% of the time. Lookup functions / sumproducts return relevant data. If the user wants to see older data then they can overtype the date without actually overtyping anything and see older data. Deleting the entered date just brings back the most current date (in the picture). It works great. Or at least it used to.

Answer 3

Nice to see you are still here. 

Hi,

Yes, I’m still here!

I think you might be right, I too can’t get it to work in 2010, the picture is selected instead of the cells behind.

But it does still work in Excel 2007.

May I ask why you want to use this strange feature? 

Cheers

Rich

Answer 4

Hi,

You can add the "Camera" tool to the QAT.  Was that what you wanted?  Not sure whether you still need to do the "save the workbook as an Excel 5.0/95 Workbook. Then reopen it..." trick detailed at the link you posted...

Hope that helps.

Cheers

Rich