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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro from active workbook whose name keeps changing 20
Macros across multiple files 1
Open files from folder by matching name 1
File open and close, get some data 2
Workbook_Open command fails and blows up all cell formulas 2
Opening and Naming Files 7
Open four Wbooks, copy four columns from each to Master Wbook 16
Hidden File Extensions generating errors 1

Back
Top