Formulas showing in Sheet

I distributed a test EXE with (I thought) right-click disabled, but for some reason the client was still able to right-click. That’s probably finger trouble on my part - but as part of right clicking around to test it - the user managed to somehow get the sheet to display formulas in the sheet. The Workbook/Worksheet(s) are protected and Worksheet protects from selection, so you cannot select a formula cell. But somehow - he managed to get the sheet to display the formulas? Any idea what has gone on here?

Does your workbook use the Application.EnableEvents property?
Do you use XLS Padlock formula protection? And do you know the Excel version of that user?

Hi

Will have to find out the version of Excel.

I am using Excel Automation for formula protection, I am not using Padlock formula protection.

I use the .EnableEvents property in a few places. Mainly in routines where I am clearing out all user entries and establishing default values in several cells. I turn off EnableEvents prior to doing this and turn it back on. This code is run by the user clicking a button in the sheet.

Ken