Disable "The cell or chart you are trying to change is protected..." alert.

[albertrl]

I have an Excel application with several information only worksheets on which all the cells are locked. Is it possible to disable the alert that pops up when a user tries to select a cell on one of these sheets? I thought that application.displayalerts=false in the selection change event would work, but it doesn't.

Not that big a deal, but it would make for a cleaner user experience if they didn't get the alert.

Thanks!

[Andy Pope]

Hi,

If you uncheck the 'Select locked cells' item when protecting the sheet the user will not be allowed to select cells and therefore will not see the dialog.

[albertrl]

Hi,

If you uncheck the 'Select locked cells' item when protecting the sheet the user will not be allowed to select cells and therefore will not see the dialog.

Thanks for the reply, Andy. In my vba code, I already have

ActiveSheet.EnableSelection = _ 
Excel.XlEnableSelection.xlNoSelection 

in the sheet activate event, and I went back and made sure the 'Select locked cells' (and 'Select unlock cells') item isn't checked. I still get the alert when a user double clicks on the sheet. Any other ideas?

[jkc72001]

The ability to control what is locked I think came in Excel 2002 and is not available in 2000. When you chose to lock the sheet, you are prompeted to what you want to allow (checks means OK). So if you want to allow someone to click on the sheet, make sure you allow selecting locked and unlocked cells.

However, double clicking on a cell puts Excel into the edit cell mode which will only be allowed in unlocked cells (thats the point of locking). I dont think there is a way of allowing a double click short of unlocking the cell and/or sheet.