Cannot insert pictures, shapes nor diagrams in worksheet

**Mike1001** · 03-06-2012, 04:12 AM

I am having an Excel 2010 workbook with macros. Neither book nor worksheets are protected nor shared.
I had a macro button in the sheet which has disappeared.
When trying to insert a picture, a shape, a diagram or controls in draft mode, all of those functions appear disabled in the menu.
I tried in German and American environment, as .xlsm and as .xls in compatibility mode - same issue.
I tried in normal view, page layout, page break preview mode, panes frozen or not - same again.

Does anyone have any idea why this file won't even let me insert a shape?

Any help will be appreciated! Thanks in advance!

Mike

**vlady** · 03-06-2012, 04:22 AM

hello
try..

"Excel Options"
"Advanced"
"Display options for this workbook"
"For objects, show".
"All"

**Mike1001** · 03-06-2012, 04:26 AM

Thanks, vLady, you saved my day!
That was a fast professional answer!

**Winon** · 03-06-2012, 04:30 AM

Hello Mike1001,

vlady may be on to something. If that does not solve your problem, then.

Don't you perhaps have EnableEvents or ScreenUpdating in your code set to "False" somewhere in your Code?

It is difficult to asses the problem without seeing a sample workbook with your code.

**vlady** · 03-06-2012, 04:42 AM

Your welcome, but again you should look at the code as stated by Winon.

What triggered it???...

If just plain mistake of ticking that radio button then fine.

good luck.

**Mike1001** · 03-06-2012, 05:26 AM

No, there is no other problem. Thank you for your continued efforts.

I have reasons to believe that just somebody was playing around with those settings and I just wasn't able to figure that out on my own.

I am pretty good at Excel VBA, so those questions are not relevant to the problem.

Thanks again!

Now, how can I tag this thread as [SOLVED]. I can't seem to find that option any more in the new website layout.

Mike

**akgary** · 01-11-2015, 05:58 PM

I am having this same problem - using Office 2013. Display ALL was already checked. I unchecked and checked again - but nada. Interestingly - the image is there - I can only see it in print preview and when printed. Ideas?

**FDibbins** · 01-11-2015, 06:01 PM

akgary, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**FDibbins** · 01-11-2015, 06:01 PM

akgary, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.