Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
User wise hide column
Hello,
Please anyone help me, I have 2 question a b c d e f g h i j k l m n o p 1 2 My excel sheet have more column. 1. I want hide column user wise. each user have use 2 or 3 column. so i want hide column user wise. 2. can i give the user wise rights for my excel sheet. like READ or CHANGE. It is possible. Pl tell me and give example Thanks RKS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
User wise hide column
If the data that is being hidden should not be seen by the other users, then
don't put it in excel. Even though you could hide columns and protect the worksheet, this kind of protection is easily broken by anyone who wants to see that info. But you may want to look at Custom Views. You can hide the columns you don't want to see, then apply View|Custom View (xl2003 menu system). If you give the views nice names (names of the users???), then they can just use view|custom view|show to see their data. RKS wrote: Hello, Please anyone help me, I have 2 question a b c d e f g h i j k l m n o p 1 2 My excel sheet have more column. 1. I want hide column user wise. each user have use 2 or 3 column. so i want hide column user wise. 2. can i give the user wise rights for my excel sheet. like READ or CHANGE. It is possible. Pl tell me and give example Thanks RKS -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can recalculation be set to "row wise" or column wise" ? | Excel Discussion (Misc queries) | |||
Sum on rows column wise - Strange error | Excel Worksheet Functions | |||
wise ass who changed column headers to numbers instead of letter | Excel Discussion (Misc queries) | |||
Data row wise, formula column wise | Excel Discussion (Misc queries) | |||
Delete row wise duplicates & colomun wise simultaneously excel | Excel Worksheet Functions |