Hi
I am sure there is a very simple answer to my problem, and have searched, but am having little luck so ask for some help please.
The issue is (I do attach a worksheet) that I need to hide the formula bar, please read on it's not as simple as that.
Basically I have a sheet with tasks on it for students, it also contains the answers which are hidden with conditional formatting (courtesy of support from here, thank you) and appear when a password is entered. This all works great. However, the students can see the answers and the password in the IF statement if they look at the formula bar. I knew this would be an issue so hid the bar before making the file available to download to the students. However, when they open the file the formula bar isn't hidden, the normal convention of hiding is obviously machine specific. Problem not solved.
So I did my research and came across this code:
I have used this and again, whilst it works for me, it doesn't work for other users when they open it. So, to conclude, I need something that hides the formula before all users of this file. Or, something which hides the contents of the formula bar.
Apologies if this seems very simple, but help is much appreciated as it will benefit my students greatly.
Thanks in advance.
Bookmarks