Show Comments on Protected Sheet

[Guest]

When my worksheet is unprotected I can place my cursor on the cell that has a
comment attached to it and the comment will display, but when I protect the
worksheet this doesn't apply. I must click on unhide comment to see the
comment instead of just placing my cursor on the cell with the comment. How
can I fix this so that I can get the same affect as if it was unprotected?

Thank you,
Sarah

 

[Jim Rech]

I assume by 'cursor' you mean mouse pointer. When I place my mouse pointer
over a cell with a comment, the comment appears whether the workbook is
protected (Tools, Protection, Protect Sheet) or not. I don't know why you
wouldn't see this.

--
Jim
| When my worksheet is unprotected I can place my cursor on the cell that
has a
| comment attached to it and the comment will display, but when I protect
the
| worksheet this doesn't apply. I must click on unhide comment to see the
| comment instead of just placing my cursor on the cell with the comment.
How
| can I fix this so that I can get the same affect as if it was unprotected?
|
| Thank you,
| Sarah

 

[Guest]

Yes I meant mouse pointer.

I have an autofilter on that cell. If I remove the autofilter, then yes I
can view the comment with or without the worksheet protection.

So how can I view it having the autofilter on?

 

[Guest]

I figured it out. Thanks.

 

[Guest]

Beijing

Area postalcode Tel Code Area Postalcode Tel Code
Beijing 100000 010 Tong County 101100 010
Pinggu County 101200 010 Shunyi County 101300 010
Huanrou County 101400 010 MIyun County 101500 010
Yanqing County 102100 010 Changping County 102200 010
Mentougou District 102300 010 FangshanDistrict 102400 010
Yanshan District 102500 010 Daxing County 102600 010


Shanghai
Area postalcode Tel Code ¡¡ Area postalcode Tel Code
Shanghai 200000 021 Jinjiao District 200100 021
shanghai County 201100 021 Chuansha County 201200 021
Nanhui County 201300 021 Fengxian County 201400 021
Jinshan County 201500 021 Songjiang County 201600 021
Qingqu County 201700 021 Jiading County 201800 021
Baoshan County 201900 021 Chongming County 202100 021
County 202204 ¡¡ ¡¡ ¡¡ ¡¡

Tianjin
Area postalcode Tel Code Area postalcode Tel Code
Tianjin 300000 022 Tanggu 300450 ¡¡
Hangu 300480 ¡¡ ninghe District 301500 022
Jinghai County 301600 022 Wuqing District 301700 022
Baodi County 301800 022 County 301900 022
Dagang District 300270 ¡¡ ¡¡ ¡¡ ¡¡

Inner Mongolia
Area Postalcode Tel Code Area Postalcode Tel Code
Huolinguole 029200 0485 Jining 012000 0474
Zalaidui 162600 0472 Baotou 014000 0472
Linhe 015000 0478 Wuhai 016000 0473
Dongsheng 017000 0477 Tongliao 028000 0475
Chifeng 024000 0476 Yakeshi 022100 0471

Shanxi Province
Area Postalcode Tel Code Area Postalcode Tel Code
Taiyuan 030000 0351 Yuci 030600 0354
xinzhou 034000 0350 Datong 037000 0352
Linfen 041000 0357 Houma 043000 0365
Yunchang 044000 0359 Yangquan 045000 0353
Changzhi 046000 0355 Jincheng 048000 0356

Hebei Province
Area Postalcode Tel Code Area Postalcode Tel Code
Shijiazhuang 050000 0311 nangong 051800 0327
Xinji 052300 0315 Hengshui 053000 0318
Xingtai 054000 0319 Shahe 054101 0319
Handan 056000 0310 Cangzhou 061000 0317
Botou 062100 0339 Renqiu 062500 0326
Tangshan 063000 0315 Qinghuangdao 066000 0335
Beidai 066100 ¡¡ Chengde 067000 0314
Baoding 071000 0312 Zhuozhou 072700 0323
Dingzhou 073000 0324 Zhangjiakou 075000 0313
Langdan 102800 0316 ¡¡ ¡¡ ¡¡
.......

http://www.china-tour.cn/Area_Code/Area_Code_Zipcode.htm