View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default 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!