+ Reply to Thread
Results 1 to 4 of 4

Hide all visible comments in sheet

  1. 01-26-2017, 03:18 AM #1
    Max, Singapore
    Max, Singapore is offline
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Hide all visible comments in sheet

    Looking for help to generalize the recorded sub below to check through and hide all visible comments in the sheet ... thanks

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-26-2017, 03:30 AM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Hide all visible comments in sheet

    May be
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 01-26-2017, 05:17 AM #3
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Hide all visible comments in sheet

    Hi,

    It is probably more efficient to only loop through comments
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  4. 01-30-2017, 09:58 PM #4
    Max, Singapore
    Max, Singapore is offline
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: Hide all visible comments in sheet

    Many thanks to both contributors, much appreciated. Good learnings too, on the generic methods.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. hide all comments using VBA
    By jjjjjjjjunit in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-04-2017, 05:56 PM
  2. [SOLVED] Hide comments
    By marcinpec in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2014, 12:41 AM
  3. how to ignore hidden sheet when renaming all visible sheets and reordering all visible she
    By qarbiq in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-06-2014, 02:14 AM
  4. Find last visible row with data in sheet and hide unused columns
    By specialk610 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2013, 10:04 AM
  5. [SOLVED] Hide excel sheets but visible after clicking on hyperlink from main sheet.
    By naveen4pundir in forum Excel General
    Replies: 2
    Last Post: 03-29-2012, 02:16 AM
  6. How to hide rows that contain Comments
    By Steve_al in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-14-2009, 10:38 AM
  7. Check Box to switch make comments visible or invisible
    By DanHegarty in forum Excel General
    Replies: 1
    Last Post: 06-10-2006, 11:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1