Thread: User Form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mazu mazu is offline
external usenet poster
 
Posts: 6
Default 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.