View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mworth01 mworth01 is offline
external usenet poster
 
Posts: 1
Default Flashing worksheets behind a userform

I have a database that I would like to remain invisible to the user. I
have set up several user forms that allow the user to input new data,
search, modify and delete existing data. As the user jumps back and
forth between user forms, the screen flashes in the background.
Application.ScreenUpdating = False did not cure this problem.

In addition, when the user selects a name from a drop down box in the
form, the database jumps to that row in the background. As I stated
before, I don't want the user to even see the database. But if I try
to hide that worksheet (using Format, Sheet, Hide), then my user form
crashes when I try to call it. Any ideas on either of these problems?
Thanks in advance.


---
Message posted from http://www.ExcelForum.com/