Excel 97 Protect but allow comments
 

I know you can do this on XP but is there anyway of protecting a sheet or
book but still allow users to add cell comments with Excel 97? Many thanks.
Sally T

Hi
AFAIK you have to at least unlock the respective cells before protecting the
sheets

--
Regards
Frank Kabel
Frankfurt, Germany
"sally t" schrieb im Newsbeitrag
...
I know you can do this on XP but is there anyway of protecting a sheet or
book but still allow users to add cell comments with Excel 97? Many
thanks.
Sally T

I know a techie that has managed to achieve this without unlocking respective
cells, because users need to be able to add comments but not change the
content of the cells - will it have been done using a macro or something in
VB? Ta

Sall

"Frank Kabel" wrote:

Hi
AFAIK you have to at least unlock the respective cells before protecting the
sheets

--
Regards
Frank Kabel
Frankfurt, Germany
"sally t" schrieb im Newsbeitrag
...
I know you can do this on XP but is there anyway of protecting a sheet or
book but still allow users to add cell comments with Excel 97? Many
thanks.
Sally T

If you do:

Tools|protection|protect sheet
You should see an option for "edit objects"
(I don't recall the wording for xl97, but if you allow users to edit objects,
then they can add/modify/delete comments--as well as other objects
(shapes/controls).)



sally t wrote:

I know you can do this on XP but is there anyway of protecting a sheet or
book but still allow users to add cell comments with Excel 97? Many thanks.
Sally T

--

Dave Peterson

"Dave Peterson" wrote:

If you do:

Tools|protection|protect sheet
You should see an option for "edit objects"
(I don't recall the wording for xl97, but if you allow users to edit objects,
then they can add/modify/delete comments--as well as other objects
(shapes/controls).)



sally t wrote:

I know you can do this on XP but is there anyway of protecting a sheet or
book but still allow users to add cell comments with Excel 97? Many thanks.
Sally T

--

Dave Peterson

Thank you Dave. I will try that.

Cheers
and happy christmas!

Sally

"Dave Peterson" wrote:

If you do:

Tools|protection|protect sheet
You should see an option for "edit objects"
(I don't recall the wording for xl97, but if you allow users to edit objects,
then they can add/modify/delete comments--as well as other objects
(shapes/controls).)



sally t wrote:

I know you can do this on XP but is there anyway of protecting a sheet or
book but still allow users to add cell comments with Excel 97? Many thanks.
Sally T

--

Dave Peterson

Excel 97 the dialog box has 3 options when protecting the sheet.

Protect worksheet for

Contents
Objects
Scenarios

De-selecting Objects will allow the insertion of Comments in locked cells as
Dave points out.

Gord Dibben Excel MVP

On Tue, 21 Dec 2004 15:02:35 -0600, Dave Peterson
wrote:

If you do:

Tools|protection|protect sheet
You should see an option for "edit objects"
(I don't recall the wording for xl97, but if you allow users to edit objects,
then they can add/modify/delete comments--as well as other objects
(shapes/controls).)



sally t wrote:

I know you can do this on XP but is there anyway of protecting a sheet or
book but still allow users to add cell comments with Excel 97? Many thanks.
Sally T

Thanks for keeping xl97 alive and kicking <vbg.

Gord Dibben wrote:

Excel 97 the dialog box has 3 options when protecting the sheet.

Protect worksheet for

Contents
Objects
Scenarios

De-selecting Objects will allow the insertion of Comments in locked cells as
Dave points out.

Gord Dibben Excel MVP

On Tue, 21 Dec 2004 15:02:35 -0600, Dave Peterson
wrote:

If you do:

Tools|protection|protect sheet
You should see an option for "edit objects"
(I don't recall the wording for xl97, but if you allow users to edit objects,
then they can add/modify/delete comments--as well as other objects
(shapes/controls).)



sally t wrote:

I know you can do this on XP but is there anyway of protecting a sheet or
book but still allow users to add cell comments with Excel 97? Many thanks.
Sally T

--

Dave Peterson