ExcelBanter - XL2002 - Disable 'clear all' when protected

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - XL2002 - Disable 'clear all' when protected (https://www.excelbanter.com/excel-discussion-misc-queries/213259-xl2002-disable-clear-all-when-protected.html)

Trevor Williams

XL2002 - Disable 'clear all' when protected

Hi All

Is it possible to disable the 'clear' options from the Edit | Clear menu?
Even when I lock the sheet and workbook the user can still use it.

Thanks

Trevor Williams

All times are GMT +1. The time now is 07:07 PM.