Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Champaign, IL, USA, Illinois, USA
    Posts
    20
    Thanks
    0
    Thanked 1 Time in 1 Post

    Trapping an Excell Error Code (2000)

    Can I intercept the error message that occurs when I press a key on a protected sheet? At the time no VBA program is running, so I can

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trapping an Excell Error Code (2000)

    The only thing that I can see that you can do would be to use the Worksheet Selection Change event routine. In that routine, you could check to see if the cell being selected is one of your protected cells and if it is don't allow it to be selected.
    Legare Coleman

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Trapping an Excell Error Code (2000)

    This might be something you've already thought of but anyway...
    I assume you need to be an unprotected cell to go ahead and work.
    If you save the spreadsheet with an unprotected cell <font color=blue>selected</font color=blue> it will open with that cell selected. I also like to change the background colour of unprotected cells as another clue to the user about where they can "go".
    This is not the VBA solution you are looking for - but something i'd do along with the VBA.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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