hide column with password
 

Hi all.
I have a spreadsheet that I want to place on a shared drive. One column
contains confidential information such as employee name and account balane. I
want to hide the name column so that only I (or others with the password)
have access to that column, but I want others to be able to view and change
the rest of the data.That is, I want them to be able to chane rows insert
columns ect. but I don't want them to.
Is there a way to do this?
Thanks

hide column with password
 

If that information cannot be shared with others, then don't put it into an
excel workbook.

If you have to, then don't share it with others.

Excel's worksheet protection is easily broken. It's designed to keep people
from writing over formulas (and the like). It's not meant to protect
information like this.



checkQ wrote:

Hi all.
I have a spreadsheet that I want to place on a shared drive. One column
contains confidential information such as employee name and account balane. I
want to hide the name column so that only I (or others with the password)
have access to that column, but I want others to be able to view and change
the rest of the data.That is, I want them to be able to chane rows insert
columns ect. but I don't want them to.
Is there a way to do this?
Thanks

--

Dave Peterson

hide column with password
 

Don't go down that road.

Excel's internal security on password-protecting worksheets is very weak.

Anyone with access to the internet can find a password cracker in a heartbeat.

The rule is..........if you don't want anyone to see the data............remove
it from the workbook.


Gord Dibben MS Excel MVP


On Sun, 11 Feb 2007 09:32:00 -0800, checkQ
wrote:

Hi all.
I have a spreadsheet that I want to place on a shared drive. One column
contains confidential information such as employee name and account balane. I
want to hide the name column so that only I (or others with the password)
have access to that column, but I want others to be able to view and change
the rest of the data.That is, I want them to be able to chane rows insert
columns ect. but I don't want them to.
Is there a way to do this?
Thanks

hide column with password
 

Actually, I don't believe you need to even bother breaking the worksheet
protection. If col D is hidden, select columns C through E and copy/paste to
an unprotected sheet and unhide the column w/the info on the unprotected
sheet.

"Dave Peterson" wrote:

If that information cannot be shared with others, then don't put it into an
excel workbook.

If you have to, then don't share it with others.

Excel's worksheet protection is easily broken. It's designed to keep people
from writing over formulas (and the like). It's not meant to protect
information like this.



checkQ wrote:

Hi all.
I have a spreadsheet that I want to place on a shared drive. One column
contains confidential information such as employee name and account balane. I
want to hide the name column so that only I (or others with the password)
have access to that column, but I want others to be able to view and change
the rest of the data.That is, I want them to be able to chane rows insert
columns ect. but I don't want them to.
Is there a way to do this?
Thanks

--

Dave Peterson

hide column with password
 

OK

"Dave Peterson" wrote:

If that information cannot be shared with others, then don't put it into an
excel workbook.

If you have to, then don't share it with others.

Excel's worksheet protection is easily broken. It's designed to keep people
from writing over formulas (and the like). It's not meant to protect
information like this.



checkQ wrote:

Hi all.
I have a spreadsheet that I want to place on a shared drive. One column
contains confidential information such as employee name and account balane. I
want to hide the name column so that only I (or others with the password)
have access to that column, but I want others to be able to view and change
the rest of the data.That is, I want them to be able to chane rows insert
columns ect. but I don't want them to.
Is there a way to do this?
Thanks

--

Dave Peterson

hide column with password
 

Thanks JMB I think I will create 2 worksheets one for my self and one for the
shared drive. The one on the shared drive will be the exact same worksheet
however it will exlude the column

"JMB" wrote:

Actually, I don't believe you need to even bother breaking the worksheet
protection. If col D is hidden, select columns C through E and copy/paste to
an unprotected sheet and unhide the column w/the info on the unprotected
sheet.

"Dave Peterson" wrote:

If that information cannot be shared with others, then don't put it into an
excel workbook.

If you have to, then don't share it with others.

Excel's worksheet protection is easily broken. It's designed to keep people
from writing over formulas (and the like). It's not meant to protect
information like this.



checkQ wrote:

Hi all.
I have a spreadsheet that I want to place on a shared drive. One column
contains confidential information such as employee name and account balane. I
want to hide the name column so that only I (or others with the password)
have access to that column, but I want others to be able to view and change
the rest of the data.That is, I want them to be able to chane rows insert
columns ect. but I don't want them to.
Is there a way to do this?
Thanks

--

Dave Peterson