LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to Lock cells and have them be unlocked based on a cell being

To anybody kind enough to take the time to read my post,

I am working on a very simple and basic excel workbook in which I have
many work sheets for different clients with a questionnaire that each
client must complete


One of the questions requires either it be left blank or marked with
an "x".


The question is located in column S and applies to all account of the
clients. If an "x' is placed, then I would like the three following
columns to be unlocked (column T, U, V) so that they can be answered.

Therefore if row 12 has S12 marked with an "x",then T12:V12 will be
unlocked. However if S13 is left blank then S13:V13 are left locked and so
on.....


Is there anybody who can help me.


Thank you so much for your time,


Hakan

Please email me for any suggestions.

All the best


 
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
lock cells based on interior color MIke Excel Discussion (Misc queries) 4 December 27th 07 08:59 PM
lock cells based on formula MIke Excel Programming 4 November 15th 07 07:31 PM
lock cells based on formula result MIke Excel Discussion (Misc queries) 1 October 26th 07 03:24 PM
Moving from unlocked cells to unlocked cells in an excel form Stacey Lee Excel Worksheet Functions 1 April 24th 06 08:44 PM
How do I lock all cells in Excel except 2 which I need unlocked? Alex Excel Discussion (Misc queries) 1 August 18th 05 03:30 PM


All times are GMT +1. The time now is 07:35 AM.

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"