I have a document which is shared, but I need to be able to edit/modify
comments. I can't seem to do this without removing sharing, which defeats
the purpose of sharing for tracking purposes. Please advise how I can edit
comments and still preserve tracking data?
--
http://www.fyi.bz

I think it's not the sharing that's the problem. I think it's the way you
protected the worksheet--and to remove the protection of the worksheet, you have
to unshare the workbook.

But if you protect the worksheet, but allow the user to Edit Objects (on that
Tools|Protection|Protect sheet dialog), then you can add/edit/delete
comments--as well as shapes and other objects.



Cadwan wrote:
>
> I have a document which is shared, but I need to be able to edit/modify
> comments. I can't seem to do this without removing sharing, which defeats
> the purpose of sharing for tracking purposes. Please advise how I can edit
> comments and still preserve tracking data?
> --
> http://www.fyi.bz

--

Dave Peterson

Thanks Dave,

I will check protection and, if necessary, remove sharing to revise
protection.
--
http://www.fyi.bz


"Dave Peterson" wrote:

> I think it's not the sharing that's the problem. I think it's the way you
> protected the worksheet--and to remove the protection of the worksheet, you have
> to unshare the workbook.
>
> But if you protect the worksheet, but allow the user to Edit Objects (on that
> Tools|Protection|Protect sheet dialog), then you can add/edit/delete
> comments--as well as shapes and other objects.
>
>
>
> Cadwan wrote:
> >
> > I have a document which is shared, but I need to be able to edit/modify
> > comments. I can't seem to do this without removing sharing, which defeats
> > the purpose of sharing for tracking purposes. Please advise how I can edit
> > comments and still preserve tracking data?
> > --
> > http://www.fyi.bz
>
> --
>
> Dave Peterson
>

Tried changing the permissions to allow editing of objects. Also set up a
Range of cells containing comments which may be edited w/o password
entry...no avail. Ready for another suggestion.
--
http://www.fyi.bz


"Dave Peterson" wrote:

> I think it's not the sharing that's the problem. I think it's the way you
> protected the worksheet--and to remove the protection of the worksheet, you have
> to unshare the workbook.
>
> But if you protect the worksheet, but allow the user to Edit Objects (on that
> Tools|Protection|Protect sheet dialog), then you can add/edit/delete
> comments--as well as shapes and other objects.
>
>
>
> Cadwan wrote:
> >
> > I have a document which is shared, but I need to be able to edit/modify
> > comments. I can't seem to do this without removing sharing, which defeats
> > the purpose of sharing for tracking purposes. Please advise how I can edit
> > comments and still preserve tracking data?
> > --
> > http://www.fyi.bz
>
> --
>
> Dave Peterson
>

I don't have one.

Sorry.

Cadwan wrote:
>
> Tried changing the permissions to allow editing of objects. Also set up a
> Range of cells containing comments which may be edited w/o password
> entry...no avail. Ready for another suggestion.
> --
> http://www.fyi.bz
>
> "Dave Peterson" wrote:
>
> > I think it's not the sharing that's the problem. I think it's the way you
> > protected the worksheet--and to remove the protection of the worksheet, you have
> > to unshare the workbook.
> >
> > But if you protect the worksheet, but allow the user to Edit Objects (on that
> > Tools|Protection|Protect sheet dialog), then you can add/edit/delete
> > comments--as well as shapes and other objects.
> >
> >
> >
> > Cadwan wrote:
> > >
> > > I have a document which is shared, but I need to be able to edit/modify
> > > comments. I can't seem to do this without removing sharing, which defeats
> > > the purpose of sharing for tracking purposes. Please advise how I can edit
> > > comments and still preserve tracking data?
> > > --
> > > http://www.fyi.bz
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Thanks anyway!
--
http://www.fyi.bz


"Dave Peterson" wrote:

> I don't have one.
>
> Sorry.
>
> Cadwan wrote:
> >
> > Tried changing the permissions to allow editing of objects. Also set up a
> > Range of cells containing comments which may be edited w/o password
> > entry...no avail. Ready for another suggestion.
> > --
> > http://www.fyi.bz
> >
> > "Dave Peterson" wrote:
> >
> > > I think it's not the sharing that's the problem. I think it's the way you
> > > protected the worksheet--and to remove the protection of the worksheet, you have
> > > to unshare the workbook.
> > >
> > > But if you protect the worksheet, but allow the user to Edit Objects (on that
> > > Tools|Protection|Protect sheet dialog), then you can add/edit/delete
> > > comments--as well as shapes and other objects.
> > >
> > >
> > >
> > > Cadwan wrote:
> > > >
> > > > I have a document which is shared, but I need to be able to edit/modify
> > > > comments. I can't seem to do this without removing sharing, which defeats
> > > > the purpose of sharing for tracking purposes. Please advise how I can edit
> > > > comments and still preserve tracking data?
> > > > --
> > > > http://www.fyi.bz
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

I'd try it again. It worked for me in xl2003 and earlier versions, too.

Cadwan wrote:
>
> Thanks anyway!
> --
> http://www.fyi.bz
>
> "Dave Peterson" wrote:
>
> > I don't have one.
> >
> > Sorry.
> >
> > Cadwan wrote:
> > >
> > > Tried changing the permissions to allow editing of objects. Also set up a
> > > Range of cells containing comments which may be edited w/o password
> > > entry...no avail. Ready for another suggestion.
> > > --
> > > http://www.fyi.bz
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > I think it's not the sharing that's the problem. I think it's the way you
> > > > protected the worksheet--and to remove the protection of the worksheet, you have
> > > > to unshare the workbook.
> > > >
> > > > But if you protect the worksheet, but allow the user to Edit Objects (on that
> > > > Tools|Protection|Protect sheet dialog), then you can add/edit/delete
> > > > comments--as well as shapes and other objects.
> > > >
> > > >
> > > >
> > > > Cadwan wrote:
> > > > >
> > > > > I have a document which is shared, but I need to be able to edit/modify
> > > > > comments. I can't seem to do this without removing sharing, which defeats
> > > > > the purpose of sharing for tracking purposes. Please advise how I can edit
> > > > > comments and still preserve tracking data?
> > > > > --
> > > > > http://www.fyi.bz
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson