+ Reply to Thread
Results 1 to 2 of 2

How do I make comments invisible to certain users?

  1. #1
    Forum Contributor sauerj's Avatar
    Join Date
    11-11-2009
    Location
    Lafayette, IN
    MS-Off Ver
    Excel 2019
    Posts
    163

    Red face How do I make comments invisible to certain users?

    We use an excel sheet to publish work schedules to work place operators. We would like to put comments on cells, but not allow operators to see these comments. These comments deal w/ private personnel issues so rightfully should not be made public. Current securities force operators to open file in READ ONLY format (per user network profiles). Is it possible to do something that will make comments invisible to these users even if they hover their mouse over cell? The little red comment flag (corner of cell) can either be visible or not (perfer visible). Thanks, sauerj
    Last edited by sauerj; 04-12-2010 at 09:43 AM.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: How do I make comments invisible to certain users?

    I don't think that this is possible, you can hide the comment indicators in Options but it won't stop someone unhiding them. Your best option will probably be to distribute a copy of the workbook with all the comments removed.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1