Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509

    Unanswered: Change error message for locked cells.

    I have setup an excel spreadsheet that is totally locked except for 15 cells that are highlighted with yellow. When they attempt to type into any of the cells that are protected, the standard error message dialog box is displayed. Is there anyway that I can intercept the error and display my own message to tell the user that they may only type in the highlighted cells? We are using Office 2000.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Never mind, I setup an automatic macro on worksheet open that will only allow the user to access unlocked cells. They can't even click on locked cells. Thanks for anyone who was looking into this for me.
    Last edited by beilstwh; 03-09-05 at 16:27.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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