Results 1 to 1 of 1

Thread: Lock worksheet

  1. #1
    Join Date
    Dec 2004
    Posts
    78

    Question Unanswered: Lock worksheet

    Hi All,

    I have a button on a worksheet that will lock the worksheet.

    Following should also happen when file is locked (and ONLY for this file - not for other files that are open)

    Disable all menus like edit, view etc except file
    Disable all toolbars
    Disable rightclick
    Disable all manual shortcuts like ^C, ^V etc

    Basically user should not be able to do any physical changes if sheet is locked.

    Thanks.

    ~BS
    Last edited by bhavesh78; 01-20-05 at 14:13.

Posting Permissions

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