ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to unhide and pictures in excel (https://www.excelbanter.com/excel-discussion-misc-queries/246498-how-unhide-pictures-excel.html)

TUNGANA KURMA RAJU

How to unhide and pictures in excel
 
In one of my w/books I used McGimpsyes's macro "Looking up and displying
pictures based on a cell value",http://mcgimpsey.com/excel/lookuppics.html
,by which all the pictures in the w/sheet are hidden.How to unhide all these
pictures by which I can edit these pictures .

Dave Peterson

How to unhide and pictures in excel
 
JE has a line of code that hides all the pictures.

Me.Pictures.Visible = False

You can change it to:
Me.Pictures.Visible = True

and make that recalc that sheet.

Remember to change the code when you're done.



TUNGANA KURMA RAJU wrote:

In one of my w/books I used McGimpsyes's macro "Looking up and displying
pictures based on a cell value",http://mcgimpsey.com/excel/lookuppics.html
,by which all the pictures in the w/sheet are hidden.How to unhide all these
pictures by which I can edit these pictures .


--

Dave Peterson


All times are GMT +1. The time now is 03:55 AM.

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