stop view and lock columns
 

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!

stop view and lock columns
 

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

"Psychokitten" wrote in message
...
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!

stop view and lock columns
 

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!