View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin P.[_2_] Kevin P.[_2_] is offline
external usenet poster
 
Posts: 1
Default Auto Shapes in Excel is greyed out, what do I do?

Nice work..thanks

"Bob Umlas, Excel MVP" wrote:

Press ctrl/6 (you have tools/options/view/objects/hide all) -- ctrl-6 is a
3-way toggle for show all objects, hide all objects, show placeholders.
Bob Umlas
Excel MVP

"Kevin B" wrote:

Could it be due to the fact that you have either worksheet or workbook
protection on? Click TOOLS on the menu and select PROTECTION. If the
UNPROTECT item is in the cascade menu, protection is the issue.
--
Kevin Backmann


"Kevin P." wrote:

I have an Excel document that I want to add arrows to, but the autoshapes
options are all greyed out. I also tried to cut and paste an arrow from
another excel document, but it would not allow me to paste it. Is there an
option somewhere to turn on/off autoshapes?