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: 270
Default Prevent User from Going Past a Certain Cell

I have a spreadsheet where the user has to answer yes or no to 4 questions,
in cells C30, C31, C32, and C34. I do not want them to be able to select any
other unlocked cell in the spreadsheet AFTER C34 until/unless they have
answered C30, C31, C32 and C34. Can someone advise how to do this; have been
struggling for awhile and my mind is fried.....thanks...pc
 
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
How do I prevent a user from entering data in a cell? jaydub100 Excel Discussion (Misc queries) 1 August 25th 09 03:14 AM
Prevent user from using Name Matlock Excel Discussion (Misc queries) 5 March 13th 08 04:58 AM
Past Special changes results for macros... how to prevent this Matt[_33_] Excel Programming 1 September 30th 05 10:14 PM
prevent a user leaving a blank cell in excel2003 Ian Varty Excel Discussion (Misc queries) 1 April 15th 05 01:41 PM
How to Get Past the User Form? JimFor Excel Programming 2 December 26th 04 01:38 AM


All times are GMT +1. The time now is 02:49 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"