Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: Disable user interface

    I am writing data to an excel sheet that is visible and would like to keep the user from doing ANYTHING until the process is complete. is there any way to stop them from interacting with excel?

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    I think it might work to use the line:

    Code:
    ActiveSheet.Protect UserInterfaceOnly:=True
    If you want to have it occur every time the workbook is opened, then include this in the Workbook_Open code.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    For more info on approaches, consider John Walkenbach's suggestions.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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