My Excel spreadsheet will not allow me to use my Drawing Tools
 

I am trying to draw a few line objects in a sheet. I can do this in other
files - just not this one. Is there a setting I can change?

My Excel spreadsheet will not allow me to use my Drawing Tools
 

Is the worksheet protected under ToolsProtectionProtect Sheet?

Is the workbook shared under ToolsShare Workbook?

Either of the above will prevent using the Drawing Toolbar functions.

If the sheet is protected and you are using XL2002 or newer you can select "Edit
Objects" when protecting the sheet.


Gord Dibben MS Excel MVP

On Fri, 9 Mar 2007 14:55:03 -0800, kyellena
wrote:

I am trying to draw a few line objects in a sheet. I can do this in other
files - just not this one. Is there a setting I can change?