Auto Shapes in Excel is greyed out, what do I do?
 

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?

Auto Shapes in Excel is greyed out, what do I do?
 

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?

Auto Shapes in Excel is greyed out, what do I do?
 

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?

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?

Auto Shapes in Excel is greyed out, what do I do?
 

Is the sheet protected?

--
Ian
--
"Kevin P." <Kevin wrote in message
...
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?