User Form

  • Thread starter Thread starter mazu
  • Start date Start date
M

mazu

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.
 
'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" <[email protected]>
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.
 
Back
Top