how do i hide columns in excel so no one can open them.
 

for example col c is the result of col a times col b. i only want people to
see the results in col c. i don't want them to see the data in a and b. so i
hide those columns. but how do i make it so they can't unhide?? thanks,
excel 2003

how do i hide columns in excel so no one can open them.
 

Protect the worksheet. Tools menu, Protection, Protect Worksheet.
Use a password if desired.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"brianb" wrote in message
...
for example col c is the result of col a times col b. i only
want people to
see the results in col c. i don't want them to see the data in
a and b. so i
hide those columns. but how do i make it so they can't
unhide?? thanks,
excel 2003

how do i hide columns in excel so no one can open them.
 

thanks. it appears that if i don't password the protection, user can
unprotect and open those cols. is that true

"Chip Pearson" wrote:

Protect the worksheet. Tools menu, Protection, Protect Worksheet.
Use a password if desired.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"brianb" wrote in message
...
for example col c is the result of col a times col b. i only
want people to
see the results in col c. i don't want them to see the data in
a and b. so i
hide those columns. but how do i make it so they can't
unhide?? thanks,
excel 2003