Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rescue336
 
Posts: n/a
Default How to you lockout the comments in Excell from other users?

I am trying to lockout the comments in Excell so that other users can just
see the data in each cell.
  #2   Report Post  
bj
 
Posts: n/a
Default

goto <tools<options<view and select none for comments this will hide there
is a comment. If you truely want to lock it out so there is no way for them
to see the comment, it will take a fair ammount of formating and VBA code.

"rescue336" wrote:

I am trying to lockout the comments in Excell so that other users can just
see the data in each cell.

  #3   Report Post  
patrick
 
Posts: n/a
Default

You could create a second workbook for the staff to view. =sheet!1, etc.
This will not show the comments from your "master" sheet. All changes made to
your sheet will be reflected in the new sheet. Protect it to make it read
only.
Hope this helps
Pat F

"bj" wrote:

goto <tools<options<view and select none for comments this will hide there
is a comment. If you truely want to lock it out so there is no way for them
to see the comment, it will take a fair ammount of formating and VBA code.

"rescue336" wrote:

I am trying to lockout the comments in Excell so that other users can just
see the data in each cell.

Reply
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
Can I view an excell document without excell (not installed wit. Gordon Excel Discussion (Misc queries) 8 May 2nd 06 05:41 AM
Comments LilLiz Excel Discussion (Misc queries) 2 April 2nd 05 12:18 AM
How do I export comments into another excel column as cell content Hernan Excel Worksheet Functions 1 February 25th 05 02:17 PM
Can I view an excell document without excell (not installed wit. Kevin Excel Discussion (Misc queries) 1 February 16th 05 08:27 PM
lable ranges in Excell david Excel Discussion (Misc queries) 2 February 2nd 05 11:26 PM


All times are GMT +1. The time now is 08:45 AM.

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

About Us

"It's about Microsoft Excel"