Userform to load when Workbook is opened

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,
I have workbook that loads userform when the workbook is opened however
eventhough I did set screenupdating to false it first shows the workbook
briefly and then loads the form.
ıs there a way around this so that people wont see the excel sheet at all?

Thank you,Ozgur
 
If you hide the workbook and then save it, it should open as hidden - just
like personal.xls.
 
Tom thanks for your reply.
I did check the "hidden" check box in the attributes of the File-Properties
window of excel. (if I did understand it correctly I mean). I can only change
it when the workbook is closed and it did not work.
I think I got it wrong...

Thanks,
Ozgur
 
Assume your workbook is name Mybook.xls

with Mybook.xls as the active workbook, go to
go to window=>Hide in the menus

You then will have to save the file. It is probably easier to do it all in
a macro in another workbook

sub fixMybook()
Windows("MyBook.xls").Visible = False
workbooks("MyBook.xls").Save
workbooks("Mybook.xls").close
End sub

--
Regards,
Tom Ogilvy
 
Stupid Ozgur stupid Ozgur...found it :))
Thanks

Ozgur Pars said:
Tom thanks for your reply.
I did check the "hidden" check box in the attributes of the File-Properties
window of excel. (if I did understand it correctly I mean). I can only change
it when the workbook is closed and it did not work.
I think I got it wrong...

Thanks,
Ozgur
Click to expand...
 
Back
Top