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

K

kyellena

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?
 
G

Gord Dibben

Is the worksheet protected under Tools>Protection>Protect Sheet?

Is the workbook shared under Tools>Share 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
 
Top