Prev: Calculate How the Number of Specific word.
Next: Excel 2010
From: Firemann25 on 5 Apr 2010 02:06
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.
From: ozgrid.com on 5 Apr 2010 04:30
Perhaps save as 2 Workspaces?
http://www.ozgrid.com/Excel/save-as-workspace.htm



--
Regards
Dave Hawley
www.ozgrid.com

"Firemann25" <Firemann25(a)discussions.microsoft.com> wrote in message
news:BA92F134-6CDD-438A-85A8-473AC0F4D57B(a)microsoft.com...
>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.

From: Dave Peterson on 5 Apr 2010 07:36
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
 | 
Pages: 1
Prev: Calculate How the Number of Specific word.
Next: Excel 2010