Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hide a column and lock it out
I have a mailing list that I need to sent to another insurance company to
update. I want to hide some of the info so they can't "use" our mailing list. I don't want to make a new worksheet with just the info I want them to see because it is a large mailing list and I don't want to have to update a seperate list after I get the updated list back. So I want to hide a column or two and lock it out so other users can't see it. Any suggestions? |
#2
|
|||
|
|||
Tools menu..
Protect workbook click the structure box.. "Becky" wrote: I have a mailing list that I need to sent to another insurance company to update. I want to hide some of the info so they can't "use" our mailing list. I don't want to make a new worksheet with just the info I want them to see because it is a large mailing list and I don't want to have to update a seperate list after I get the updated list back. So I want to hide a column or two and lock it out so other users can't see it. Any suggestions? |
#3
|
|||
|
|||
The only way I know how to do this is to hide the columns and then protect
the worksheet with a password. They will not be able to unhide the column unless they have the password, but they can still copy the data and paste it to a new workbook and view it, so this is not a secure way of locking them out. To protect the sheet go to Tools - Protection - Protect workbook (or sheet) and then put in your password. "Becky" wrote: I have a mailing list that I need to sent to another insurance company to update. I want to hide some of the info so they can't "use" our mailing list. I don't want to make a new worksheet with just the info I want them to see because it is a large mailing list and I don't want to have to update a seperate list after I get the updated list back. So I want to hide a column or two and lock it out so other users can't see it. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stationary Column | Excel Discussion (Misc queries) | |||
Lock Column | Excel Discussion (Misc queries) | |||
Changing column size w/o losing text | New Users to Excel | |||
how do I lock column and row names on spreadsheet | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |