Forum Discussion
johnnyg00
May 20, 2020Copper Contributor
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
johnnyg00
May 21, 2020Copper Contributor
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
May 21, 2020Iron Contributor
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.