ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to lock/unlock comment ? (https://www.excelbanter.com/excel-programming/369012-how-lock-unlock-comment.html)

vumian[_40_]

how to lock/unlock comment ?
 

hi everyone,

i wanna lock my comment, it mean, it can not modify
how about 1 cell or all cells?

thank you for help.


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=567127


NickHK

how to lock/unlock comment ?
 
AFAIK, you have to Protect the sheet.

NickHK

"vumian" wrote in
message ...

hi everyone,

i wanna lock my comment, it mean, it can not modify
how about 1 cell or all cells?

thank you for help.


--
vumian
------------------------------------------------------------------------
vumian's Profile:

http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=567127





All times are GMT +1. The time now is 06:57 AM.

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