Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

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

  1. #1
    Join Date
    25th September 2005
    Posts
    2

    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!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,314

    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


  3. #3
    Join Date
    25th September 2005
    Posts
    2

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

    Quote 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
    VB:
    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 at 14:37. Reason: adding code tags please us in future

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th August 2005
    Location
    California
    Posts
    12

    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.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Chart "" Cell Entry As Non-existent Rather Than Zero
    By andrew.sawyer in forum EXCEL HELP
    Replies: 2
    Last Post: April 11th, 2007, 15:36
  2. Replies: 10
    Last Post: June 14th, 2006, 04:18
  3. Fire VBA, on "Locked,Protected and UnSelected cell?"
    By LarryLaser in forum EXCEL HELP
    Replies: 4
    Last Post: April 30th, 2006, 10:08
  4. Replies: 2
    Last Post: August 27th, 2005, 18:19
  5. Replies: 2
    Last Post: November 13th, 2003, 05:05

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno