I have a sheet setup that has 50% of the cells locked.

I need to be able to allow the user to draw arrows over
the cells that are not locked.

Basically the Right side of the sheet is for adding comments.
So I need to be able to draw on it.

Any suggestions would be greatly appreciated.

TIA

Robert

Robert

If using Excel 2002 or newer version you can checkmark "edit objects" when you
protect the sheet.

Earlier versions will probably require you to unprotect, do the drawing, then
re-protect.


Gord Dibben MS Excel MVP

On Sun, 11 Jun 2006 15:09:49 GMT, "Robert" <(E-Mail Removed)> wrote:

>I have a sheet setup that has 50% of the cells locked.
>
>I need to be able to allow the user to draw arrows over
>the cells that are not locked.
>
>Basically the Right side of the sheet is for adding comments.
>So I need to be able to draw on it.
>
>Any suggestions would be greatly appreciated.
>
>TIA
>
>Robert
>
>

That did it.

THANKS!!!!


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news(E-Mail Removed)...
> Robert
>
> If using Excel 2002 or newer version you can checkmark "edit objects" when
> you
> protect the sheet.
>
> Earlier versions will probably require you to unprotect, do the drawing,
> then
> re-protect.
>
>
> Gord Dibben MS Excel MVP
>
> On Sun, 11 Jun 2006 15:09:49 GMT, "Robert" <(E-Mail Removed)> wrote:
>
>>I have a sheet setup that has 50% of the cells locked.
>>
>>I need to be able to allow the user to draw arrows over
>>the cells that are not locked.
>>
>>Basically the Right side of the sheet is for adding comments.
>>So I need to be able to draw on it.
>>
>>Any suggestions would be greatly appreciated.
>>
>>TIA
>>
>>Robert
>>
>>
>

This works in XL97 as well, but allows one to draw on any part of the
sheet, even the protected areas.......

Vaya con Dios,
Chuck, CABGx3


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news(E-Mail Removed)...
> Robert
>
> If using Excel 2002 or newer version you can checkmark "edit objects" when
you
> protect the sheet.
>
> Earlier versions will probably require you to unprotect, do the drawing,
then
> re-protect.
>
>
> Gord Dibben MS Excel MVP
>
> On Sun, 11 Jun 2006 15:09:49 GMT, "Robert" <(E-Mail Removed)> wrote:
>
> >I have a sheet setup that has 50% of the cells locked.
> >
> >I need to be able to allow the user to draw arrows over
> >the cells that are not locked.
> >
> >Basically the Right side of the sheet is for adding comments.
> >So I need to be able to draw on it.
> >
> >Any suggestions would be greatly appreciated.
> >
> >TIA
> >
> >Robert
> >
> >
>