I get 'compile errors on a hidden sheet'.
Whilst utilities to select and lock the relevant cells are useful, ultimately they rely upon protection being applied to the workbook. To gain a measure of security, your boss has to give way on the protection issue. It may be that more operations are possible on a protected sheet than you realise. For example, the grouping and hiding of columns is possible, provided the selection of locked cells is permitted (I also allowed the insertion/deletion of columns and the formatting of columns).
The unprotected workbook that I posted, works on the basis that "If cracking the workbook takes more knowledge or time than writing it from scratch, the security level is sufficient". In case anyone looked at the workbook, all the formulas are held as the 'refers to' property of a Name. The Names are then hidden using
something that can only be done from code since there is no user interface control for this functionality. I know of an instance where this device has held a bank IT department at bay because they were looking for hidden code modules that did not exist.
A further thought: Make sure you are not sharing anything here that you wish to keep secret.
[/Q
Thank You so much PETER. Will try by protecting sheet.