LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Comments in protected cells with AutoFilter switched on

I'm using Excel 2003.

I have a protected sheet on which some of the protected cells have comments.
Some of these cells are in the header row of a table with AutoFilter enabled.
Generally comments can be viewed by hovering over the cell. However the
comments in cells which head an AutoFilter column are NOT visible when the
sheet is protected (they are fine when the protection is turned off). Is this
just a limitation or is there any way round it? Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting Comments into Cells of Protected Worksheet Steve Excel Worksheet Functions 1 March 29th 07 09:19 PM
Allowing comments in unlocked cells within protected sheet Suz Excel Discussion (Misc queries) 1 February 6th 07 07:35 PM
Protected Worksheets and Comments Darrell \(Singapore\) New Users to Excel 1 September 28th 06 04:00 PM
How to add comments/colours to cells in a protected sheet Nousj Excel Discussion (Misc queries) 2 June 21st 06 01:58 PM
Protected worksheet and comments Jack Excel Discussion (Misc queries) 1 January 26th 06 01:55 PM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"