Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
I referenced data in Text Box from an Excel sheet.
For that, I wrote the following code: Workbooks.Open Filename:= _ "C:\Documents and Settings\mxra\Desktop\SYNCHRO Project\demo data.xls" Any time I run the user form, I can see that the file is opening. How can I hide that file? So anyone open the user form will not be able to see the base file were data is referenced. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
'Turn off updates to the display screen before opening the file...
Application.ScreenUpdating = False 'Open the file ThisWorkbook.Activate 'switch back to original file. Application.ScreenUpdating = True '-- You may also want to consider hiding the display of workbook buttons in the Taskbar using... Application.ShowWindowsInTaskbar = False -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "mazu" wrote in message I referenced data in Text Box from an Excel sheet. For that, I wrote the following code: Workbooks.Open Filename:= _ "C:\Documents and Settings\mxra\Desktop\SYNCHRO Project\demo data.xls" Any time I run the user form, I can see that the file is opening. How can I hide that file? So anyone open the user form will not be able to see the base file were data is referenced. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call user form from ThisWorkbook; close file if form closed | Excel Programming | |||
Automatically add a textbox to a user form based on user requireme | Excel Programming | |||
User form ComboBox Items: Remember user entries? | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming |