LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Les Les is offline
external usenet poster
 
Posts: 240
Default Hiding columns in Excel 2003

Hi,

I do know how to hide columns but I have a problem. Say I have a worksheet
which person A uses columns A through T. I plan on using columns AA and AB
and will be entering data into those 2 columns from time to time. Now one of
my columns is my data entry, say Col AA and AB is a calculated cell which
subtracts the value I placed into col AA from one value from one of the
columns that person a is using. Once I set this up and hide my 2 columns,
and I protect the worksheet. Even protected when I place the formula say
=AA5 into some other cell anywhere on the sheet it still tells me what the
contents of that cell is even though it is hidden. I dont want the other
person to be able to view the data in my 2 cells but it doesnt matter if she
is aware that there are a few hidden columns. Perhaps someone out here can
think of a way to do this some other way??

Thanks in advance,

Les
 
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
Hiding columns in Excel - Helmut Excel Discussion (Misc queries) 2 October 9th 07 09:48 PM
hiding even (or odd) rows in excel 2003 9d1awd Excel Discussion (Misc queries) 5 February 2nd 07 06:25 PM
Recalculation on hiding rows in Excel 2003 Cantoris Excel Discussion (Misc queries) 1 December 4th 06 02:12 AM
Excel 2003 Hiding #DIV/0 in Data/Subtotal/Avg result Karl Perry Excel Discussion (Misc queries) 4 June 26th 06 08:59 PM
Excel 2003 - Protecting and Hiding Columns Peppermint Excel Discussion (Misc queries) 2 January 19th 06 04:06 PM


All times are GMT +1. The time now is 01:07 PM.

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

About Us

"It's about Microsoft Excel"