Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
open separate exterior excel windows | Excel Discussion (Misc queries) | |||
Getting Excel error when trying to hide columns. Why? | Excel Discussion (Misc queries) | |||
When I open excel document it always ask if I want to open it in . | Excel Discussion (Misc queries) | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel | |||
Excel Files Won't Open From Shortcut | Excel Discussion (Misc queries) |