Userform to load when Workbook is opened
 

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

Userform to load when Workbook is opened
 

If you hide the workbook and then save it, it should open as hidden - just
like personal.xls.

--
Regards,
Tom Ogilvy


"Ozgur Pars" wrote:

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

Userform to load when Workbook is opened
 

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

"Tom Ogilvy" wrote:

If you hide the workbook and then save it, it should open as hidden - just
like personal.xls.

--
Regards,
Tom Ogilvy


"Ozgur Pars" wrote:

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

Userform to load when Workbook is opened
 

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





"Ozgur Pars" wrote:

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

"Tom Ogilvy" wrote:

If you hide the workbook and then save it, it should open as hidden - just
like personal.xls.

--
Regards,
Tom Ogilvy


"Ozgur Pars" wrote:

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

Userform to load when Workbook is opened
 

Stupid Ozgur stupid Ozgur...found it :))
Thanks

"Ozgur Pars" wrote:

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

"Tom Ogilvy" wrote:

If you hide the workbook and then save it, it should open as hidden - just
like personal.xls.

--
Regards,
Tom Ogilvy


"Ozgur Pars" wrote:

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