Forum Discussion

johnnyg00's avatar
johnnyg00
Copper Contributor
May 20, 2020

Answer Sheet

trying to make an answer sheet for 1000 question study guide i want to be able to input answer in column A and if correct check mark in B if incorrect X in B answers are a,b,c,d,e,f

excel

3 Replies

    • johnnyg00's avatar
      johnnyg00
      Copper Contributor
      May 21, 2020

      bhushan_z 

      that's i awesome thank you but how do i do it so that they don't see the correct answer until they input answer in B column

      • bhushan_z's avatar
        bhushan_z
        Iron Contributor
        May 21, 2020

        johnnyg00 okay, I have moved correct answers to sheet 2.
        Once you update Correct Answers, make that sheet 'Very Hidden' so that users can't see it.

         

        HOW TO MAKE SHEET VERY HIDDEN:

        https://www.ablebits.com/office-addins-blog/2017/12/20/very-hidden-sheets-excel/

        refer to title "Make a worksheet very hidden by changing its Visible property"

         

        Note: This is not my blog, it's just for reference.

Resources