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

"Ultimate Don" wrote:

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.

"Andy Pope" wrote:

Hi,

Check the setting for View objects.

Office Button Excel Options Advanced Display Options for this workbook
For objects, show: All

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ultimate Don" <Ultimate wrote in message
...
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.