ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protected Sheets (https://www.excelbanter.com/excel-discussion-misc-queries/62032-protected-sheets.html)

Jolo

Protected Sheets
 
How do I allow other useres to be able to go in and insert comments on a
sheet that I have certain cells protected because I do not want them to alter
the formulas?

Paul B

Protected Sheets
 
Jolo, depends on what version you have, try this, when you go to protect the
sheet check edit objects

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jolo" wrote in message
...
How do I allow other useres to be able to go in and insert comments on a
sheet that I have certain cells protected because I do not want them to

alter
the formulas?




Jolo

Protected Sheets
 
Thank you It worked. I have been busting my head all day on this. Thanks

"Paul B" wrote:

Jolo, depends on what version you have, try this, when you go to protect the
sheet check edit objects

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jolo" wrote in message
...
How do I allow other useres to be able to go in and insert comments on a
sheet that I have certain cells protected because I do not want them to

alter
the formulas?





Paul B

Protected Sheets
 
Your welcome, thanks for the feedback

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jolo" wrote in message
...
Thank you It worked. I have been busting my head all day on this. Thanks

"Paul B" wrote:

Jolo, depends on what version you have, try this, when you go to protect

the
sheet check edit objects

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jolo" wrote in message
...
How do I allow other useres to be able to go in and insert comments on

a
sheet that I have certain cells protected because I do not want them

to
alter
the formulas?








All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com