A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

restrict view of certain cells in excel



 
 
Thread Tools Display Modes
  #1  
Old April 5th, 2010, 07:06 AM posted to microsoft.public.excel.misc
Firemann25
external usenet poster
 
Posts: 1
Default restrict view of certain cells in excel

I am trying to restrict access to some users in excel. I am trying to make
it so those that do not have the password can view the sheet "read only" but
cannot view certain cells. Those that do have the password can view all
cells.
  #2  
Old April 5th, 2010, 09:30 AM posted to microsoft.public.excel.misc
ozgrid.com
external usenet poster
 
Posts: 328
Default restrict view of certain cells in excel

Perhaps save as 2 Workspaces?
http://www.ozgrid.com/Excel/save-as-workspace.htm



--
Regards
Dave Hawley
www.ozgrid.com

"Firemann25" wrote in message
...
I am trying to restrict access to some users in excel. I am trying to make
it so those that do not have the password can view the sheet "read only"
but
cannot view certain cells. Those that do have the password can view all
cells.


  #3  
Old April 5th, 2010, 12:36 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default restrict view of certain cells in excel

If that information that should remain hidden is top secret (like social
security numbers/salaries/etc), then I wouldn't use excel for this.

Any solution that I would use would rely on macros and macros can be disabled.

And worksheet protection isn't made to protect intellectual property. It's not
very strong. It's made to help prevent users from making data entry errors.

Firemann25 wrote:

I am trying to restrict access to some users in excel. I am trying to make
it so those that do not have the password can view the sheet "read only" but
cannot view certain cells. Those that do have the password can view all
cells.


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:22 AM.


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