Hide/Unhide an Autoshape or Picture in Excel

Solved/Closed

madambath - May 10, 2010 at 07:23 AM
jerangkung - Nov 7, 2013 at 04:08 AM

Hi All,

Could anyone tell me the method to Hide/Unhide an Autoshape or Picture in Excel Spreadsheet? I know it is possible through Macro Codes, any other usual ways like hiding Columns, Rows or Sheets?

With regards,
PramodKumar

How to hide picture in excel
How to hide app store on ipad - Guide
Picture manager download - Download - Image viewing and management
How to hide call history in whatsapp ✓ - WhatsApp Forum
Number to words in excel - Guide
Convert picture to shape powerpoint - Guide

4 responses

Answer 1 / 4

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 10, 2010 at 08:16 AM

Use the properties
.visible = true and .visible = false

ActiveSheet.Pictures("Picture 2").Visible = True

Answer 2 / 4

madambath
May 11, 2010 at 01:35 AM

Thank you, this requires to execute the Code to do the job. What I need is when the file is opened the Sheet should not show some of the Autoshapes or Pictures in the sheet and keeps some other hidden.

When I run my other Marcos these Autoshapes or Pictures will be Unhide or deleted.

In this scenario if I used the Code to hide Autoshapes or Pictures in the WorksheetOpen event and executed all my other macros in the files and saved the resulting file as a "New File" and when I go back to open the "New File" some errors will be shown due to the WorksheetOpen event Code.

I hope you may understood (blame my poor language) my problem.

Thanks and Regards,
PramodKumar

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 11, 2010 at 06:08 AM

Why not enclose the part of making it visible, hidden or delete sandwiched bewteeen

On Error Resume Next

On Error goto 0

Answer 3 / 4

madambath
May 11, 2010 at 07:44 AM

Once again you did it for me! Wonderful tip, Thanks a lot.

Now my Code looks as below:

Private Sub Workbook_Open()

On Error Resume Next
ActiveSheet.Shapes("Button08").Visible = False
ActiveSheet.Shapes("Button09").Visible = False
ActiveSheet.Shapes("Button10").Visible = False
ActiveSheet.Shapes("Button 55").Visible = False
ActiveSheet.Shapes("Button 56").Visible = False
ActiveSheet.Shapes("Button 57").Visible = False
ActiveSheet.Shapes("Button 64").Visible = False
ActiveSheet.Shapes("Button 65").Visible = False
ActiveSheet.Shapes("Button 66").Visible = False
ActiveSheet.Shapes("Button 67").Visible = False
ActiveSheet.Shapes("Button 74").Visible = False
On Error GoTo 0

End Sub

With Regards,
PramodKumar

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 11, 2010 at 07:57 AM

Superb. And thanks for posting your solution. It just might help some one else too.

Similar discussions

Insert picture in Excel macro which takes the file name refrence

Hello Friends,

Kindly help me!

I am trying to insert a picture in excel macro which takes the file name reference from the D5 cell and insert the picture in I7 cell.

Example: if D5 cell is AAA2 then the picture which will be inserted in I7 would be F:\AAA2.jpg

Note:
1. I7 cell is merged cell it cover I7 to I12 & J7 to J12
2. I change the value in D5 cell only

Please help me if, I changed the value in D5 than the Picture inserted in I7 may automatically change according to the value of D5.

Kindly help me what is the function I want to insert in macro and how to call ...

Inserting an image without the white background

Hello,

I have an image that I have vectorized... or so I think I have.... and I when I try to insert it into a document this white square appears around it. I can't figure out how to move just the image and not the back ground as well.

Can anyone help me!!!???

thanks!
nSystem Configuration: Windows Vista
Internet Explorer 7.0

No display in monitor

Hello,

No image appears on my monitor. Computer starts up, power supply fan works. CPU fan also works fine. Attached side panel fan is also working. Drive sounds as if working. Boot sounds to start working (no 'beep' though). But no image. Monitor says, it's working fine, check connection. Well, Connection is fine. Can't check BIOS if I can't get an image. Is there anyone out there who can help?

view FB photos without logging in

Hello,

I'm not a facebook account holder, but my dog's daycare posts photos of the pups playing during the day that are fun and cute to look at. Up until today I was always able to go view those as like a visitor or something, but now FB is asking me to login and will not let me do anything until I do (or create an account).

I don't really care to create an FB account just to view pix of the dog at daycare, so is there anyway to circumvent this or is this new security functionality that you can't work around?

System Configuration: Windows / Chrome 62.0.3202.94

How to upload clear images on Whatsapp status?

Hello,

I need to upload clear high quality images to Whatsapp status but Whatsapp keeps blurring it, i have tried reducing the image quality / pixels / size but hasnt helped.

Please someone suggest the cure for this!

Thanks in advance.

Abby.

WhatsApp Web photos always sideways

Hello,

I have photos that I have taken with my Samsung phone and have downloaded them to a folder on my PC. When I try to send a photo via WhatsApp Web, it always sends it sideways, no matter the orientation of the original or which way I turn it in File Manager. It always sends it in Landscape mode instead of Portrait. Is there a way to rotate it in WhatsApp Web? It's driving me crazy!
However, photos taken on an iPhone that I have on my PC do show up in the correct orientation in WhatsApp Web.

Similar discussions

Subscribe To Our Newsletter!