Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
brianb
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
brianb
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
open separate exterior excel windows Jason Dove Excel Discussion (Misc queries) 18 May 3rd 05 05:22 PM
Getting Excel error when trying to hide columns. Why? MClark Excel Discussion (Misc queries) 1 April 28th 05 11:28 PM
When I open excel document it always ask if I want to open it in . dperkins Excel Discussion (Misc queries) 0 February 15th 05 08:11 PM
Unable to open excel sheet in Protected mode from VB 6.0 ourspt Setting up and Configuration of Excel 0 January 26th 05 11:07 AM
Excel Files Won't Open From Shortcut ConfusedNHouston Excel Discussion (Misc queries) 5 December 31st 04 06:25 PM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"