Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
Auto Shapes | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) |