Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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!

  • #2
    Re: Disable "The cell or chart you are trying to change is protected..." alert.

    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.

    Cheers
    Andy

    Comment


    • #3
      Re: Disable "The cell or chart you are trying to change is protected..." alert.

      Originally posted by 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.
      Thanks for the reply, Andy. In my vba code, I already have
      Code:
          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?
      Last edited by royUK; September 25th, 2005, 14:37. Reason: adding code tags please us in future

      Comment


      • #4
        Re: Disable "The cell or chart you are trying to change is protected..." alert.

        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.

        Comment

        Working...
        X