Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 171
Default 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 .
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unhide row does not unhide the hidden rows nikita Excel Worksheet Functions 4 May 24th 08 02:59 PM
Storing Clip Art pictures in My Pictures folder jfg Excel Discussion (Misc queries) 4 August 10th 07 06:12 AM
Pictures In Excel Andy@HycoMan Excel Discussion (Misc queries) 2 January 12th 07 08:39 AM
how do i unhide a worksheet in excel 2003? unhide tab don't work mikekeat Excel Discussion (Misc queries) 2 March 6th 06 03:36 AM
Excel's Compress Pictures or deleting pictures doesn't seem work guidod Excel Discussion (Misc queries) 1 January 29th 06 06:51 AM


All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"