Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Load a range of cells into a dataset with an opened workbook instance. | Excel Programming | |||
Can macro/userform run depending on HOW workbook is opened? | Excel Discussion (Misc queries) | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming |