Insert Illustrations disabled (grayed out) in Excel 2007

[Ultimate Don]

I'm just trying to insert a line but all the Insert Illustrations selections
are all grayed out.
I've check to ensure the worksheets are not Grouped or protected as
suggested elsewhere and they are not.
Any other ideas would be welcome!
Thanks, Don.

 

[Sheeloo]

Are you sure you are not in Edit mode? Press ESC and try.

Is it happening on all workbooks? Open a new one and see.

Make sure no dialog boxes are open... Is VB Editor open?

 

[FSt1]

hi
the line styles are selected AFTER you have drawn the line.
drop a line on the sheet and your line styles will be available.

Regards
FSt1

 

[Ultimate Don]

Thanks for your comments.
Not in edit mode. Nothing else open I can close Excel and then reopen and
problem persists. Not sharing workbook either.
It happens on all worksheets new and old only within this workbook. Other
workbooks are fine. I could copy over the 16 sheets but didn't want to go
through the effort as I'm sure it will happen again at some point down the
road.
Another weird item related to this workbook only (I don't see how the two
could be related but will mention it) is that if I try to insert a row it
says it cannot shift objects off sheet. I F5 goto objects and there are none,
I goto last cell and it goes to cell M350 so there is plenty of room left!
Charts are also grayed out.

 

[Ultimate Don]

Thanks for your interest and time.
Unfortunately, the point is I can't drop a line on any sheet in this
workbook. Other workbooks no problem. Something unique about this workbook
(new sheets within workbook have same problem). No Charts (grayed out) as
well.

 

[Sheeloo]

Try to select all rows after 350 and delete
Similarly delete all columns after M...

It may solve the problem.

Can you share the workbook so that I can check on my PC?

 

[Andy Pope]

Hi,

Check the setting for View objects.

Office Button > Excel Options > Advanced > Display Options for this workbook

For objects, show: All

Cheers
Andy

 

[Ultimate Don]

Andy,
Wow, that did it! I don't really see the connection but it solved both
problems, the insertion of rows/cols and being able to do chart/graphics and
insert graphics. I'm not sure why I'd change that setting but now I may use
this just to mess with people.
Thanks for your support.

 

[Ultimate Don]

Sheeloo,
Andy Pope (below) solved my problem, it was the old hide objects setting (I
didn't even realize there was such a thing).
Thanks again for your time.
v/r, Don

 

[lf]

Andy Pope,

The Setting for view objects was totally unknown to me and I was about to
start to re working on almost 80 sheets because of that and your answer to
this post just saved me doing that !

It was a nightmare for me and you just saved me from going through all that
trouble. This setting is very essential and would help alot of people like
myself, who like ultimate don had no clue it existed and how it got changed.

Thank you very much (both Andy and Ultimate don for raising the question in
the first place!)

Cheers
LF