Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flashing worksheets behind a userform
One quick fix might be to change the font color to the same as th
background color. The worksheet would be there, but the data would no be seen. Use this in place of application.screenupdating. -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flashing worksheets behind a userform
The answer from dude! is a good one but if you don't want to go down
that path you could always just hide Excel. As you're running lots of userforms, then Code: -------------------- Application.Visible = False -------------------- into the Workbook_Open sub would hide the instance of Excel. Just a thought. Geoff (TheDuck) --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flashing worksheets behind a userform
Thanks for the replies. All three of these options look like they'll
work (obviously, else you probably wouldn't have posted!). I ended up going with hiding the application as that was a request from the user to begin with. Works great. Thanks again for your help. --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flashing worksheets behind a userform
Thanks for the replies. All three of these options look like they'll
work (obviously, else you probably wouldn't have posted!). I ended up going with hiding the application as that was a request from the user to begin with. Works great. Thanks again for your help. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flashing value | Excel Discussion (Misc queries) | |||
Flashing Cell | Excel Discussion (Misc queries) | |||
Flashing cells | Excel Worksheet Functions | |||
flashing worksheets | Excel Discussion (Misc queries) | |||
Userform and Worksheets | Excel Programming |