Prev: insurance renewal formula flag needed
Next: Arrange Footer
From: Psychokitten on 8 Feb 2010 15:29
Hi,

I need to hide two columns on my worksheet such that when I send it to a
user, they cannot "unhide" the columns to see salary data. Is there a way to
hide columns and deny access to other users?

Thanks so much!
From: Don Guillett on 8 Feb 2010 15:42
You can use a macro to make the columns VERYHIDDEN and then protect your
macro code from novice users . If you send it to me I can easily take a
look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Psychokitten" <Psychokitten(a)discussions.microsoft.com> wrote in message
news:DE9BE966-948B-4D10-864D-36FE1F9772DA(a)microsoft.com...
> Hi,
>
> I need to hide two columns on my worksheet such that when I send it to a
> user, they cannot "unhide" the columns to see salary data. Is there a way
> to
> hide columns and deny access to other users?
>
> Thanks so much!

From: Luke M on 8 Feb 2010 16:05
Nope.

If you don't want them to see it, you will need to remove/delete those
columns. If the columns are used in formulas somewhere, I would make those
formulas static values.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Psychokitten" wrote:

> Hi,
>
> I need to hide two columns on my worksheet such that when I send it to a
> user, they cannot "unhide" the columns to see salary data. Is there a way to
> hide columns and deny access to other users?
>
> Thanks so much!
 | 
Pages: 1
Prev: insurance renewal formula flag needed
Next: Arrange Footer