View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paige Paige is offline
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