Excel 2010: Can't view or select Sheet Shapes which are Visible [SOLVED]

[exc4libur]

Hello guys!


I am having a bit of a problem, it looks like a bug of some kind!

I created a smartart diagram in Sheet1 3 days ago.. It was working just fine, then, all of a sudden, it just didn't display the diagrams anymore! So I pressed ALT+F10 and I saw the shapes were still there (checked visible also!). But I can't view them! S.O.S.


Please find the link to the workbook below!

https://www.dropbox.com/s/x9szax1c1zzrr8y/Structure%20-%20Copy.xlsb


I tried google but nothing so far!


Rgds!

 

[SirJB7]

Hi, exc4l1bur!


With which Excel version have you created that file? It's strange, I can retrieve shape names but not their position and even if visible I can't see them.


Regards!


PS: Besides you're missing this statement in procedure unhide_pics on module Module1 since you have an Option Explicit clause:

-----

Dim DrwObj as Object, Pict as Object

-----

 

[exc4libur]

Hi SirJB7!


Thanks for your reply, please find the info you requested below:


EXCEL 2010 (14.0.6126.5004) SP1 MSO

MS OFFICE Home and Student 2010


I still have no idea whats going on! ahhhhhhh

 

[exc4libur]

Sir!! Found the solution.


Somehow, (I dont know how) the box in [ Options / Advanced / Display / Show all objects ] was not checked!


Thanks for your attention and help!


Rgds

 

[SirJB7]

Hi, exc4l1bur!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!