Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2005

Tip: Looking for answers? Try searching our database.

Password Protect Hidden Columns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
HelsT - 23 Jun 2005 16:54 GMT
Hi,

Problem 1: I would like to be able to hide a column and make it so it
can only be unhidden with a password - but leave the rest of the
datasheet unprotected.  Is this possible?

Problem 2:

I have 3 columns of data.  

In B3 I begin a list of random words, stretching to row 346 which is
sorted alphabetically.  

In C3 I begin another list of random words which stretches to row 278.
Some of the words in this list are the same as in column B, some are not
- the words that are the same are not next to each other because the
columns were sorted alphabetically which has thrown out them of sync.

In colmun D I have a code which represents the words it sits next to in
column C (but which in no way relates to the words).  

I need to be able to match up words in column B, to column C, with the
unmatching words going to the end of the list, while keeping the code
in column D next to it's corresponding word in column C.

Is this possible?

Replies greatly appreciated.

HelsT

Signature

HelsT

Dave Peterson - 23 Jun 2005 22:46 GMT
#1.  Worksheets are protected--not parts of worksheets.
    But in xl2002+, you have finer control over what you can do on a protected
    worksheet.

    But even if you protect that worksheet with that column hidden, it
    wouldn't take much to unprotect worksheet--excel's worksheet and workbook
    (under Tools|Protection) is not made for security purposes--it's usually
    used to stop simple typos (overwriting labels or formulas).

#2.  Is this a one time thing?

If yes, maybe some manual effort.

Insert a new column between B and C.  (so that old C is now new D.)

In C3, put this:

=if(isnumber(match(b3,d:d,0)),b3,"")
Drag down to C346.

Select column C and edit|copy, edit|paste special|values to get rid of the
formulas.

Now you have the words that match up in column C.

Now insert a new column E next to column D (which was old column C).

Put this in E3:
=if(isnumber(match(d3,b:b,0)),"",d3)
And drag down to E278.

Now the words that are missing from the first list are in column E.

Select column E and edit|copy, edit|paste special|values to get rid of the
formulas.

Now be careful.  Sort column E (not any other column!).

Copy those cells with words in them under the last entry in column C (C347???).

Delete column E (we're done with it).

> Hi,
>
[quoted text clipped - 32 lines]
> HelsT's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24576
> View this thread: http://www.excelforum.com/showthread.php?threadid=381613

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.