activating userform without showing workbook

[dan2010]

Hi,

i am just wondering if there is any coding to allow userform to run without showing the workbook.my idea is to run the userform when the workbook opens and then close the workbook.

Please Login or Register  to view this content.

however, the workbook will close only after i close the userform. so does anyone know how i can change my coding to make it work?i will gladly welcome any advice or opinions

[davesexcel]

A quick example brought me this solution

Please Login or Register  to view this content.

[royUK]

You must be extremely careful with this. If an error closes the userform, then you will have an invisible instance of excel

Please Login or Register  to view this content.

[dan2010]

sorry for the late reply as i was unavaible to have access to internet until now. where am i supposed to insert the codes above? in "thisworkbook" ? or in the userform itself?

ps: the userform is supposed to run in the desktop, without showing workbook at all if possible

[Nancy123]

The following code should work fine:

Please Login or Register  to view this content.

[dan2010]

@nancy123: your code works for me, however, it hides all the excel workbooks. is it possible to hide only that workbook while leaving the other workbooks still visible? i tried using

Please Login or Register  to view this content.

but it still hides all workbooks.

[royUK]

Why do you want to hide the workbook?

If the workbook only acts as a container for the code then you should turn it into an add in

[dan2010]

@roy:my boss wants to key in data into the userform only and does not wish to see the workbook at all. i had already created a button in the userform to show the workbook when necessary. by the way, what do u mean by "If the workbook only acts as a container for the code then you should turn it into an add in"?

[royUK]

If the code is held in the workbook but nothing else, i.e. no data then an add in would be appropriate.

I can't see why not seeing the workbook is necessary, but the simplest way would be to have a blank sheet visible when inputting with the form.

With code

Please Login or Register  to view this content.

Set the form's ShowModal property to false

[dan2010]

there will be data in the workbook. technicians and engineers will enter data into the userform and it will be transferred into the workbook while admin gets to open the workbook and look at all the data keyed in by technicians and engineers.my boss wants only the userform to show for visual effect. looks neater

[royUK]

Have you tried the code that I posted?

[dan2010]

sorry for the late reply. i am unable to get a connection until now. the code doesnt work for me. i tried pasting the code in sheet 1, as well as pasting it in "thisworkbook". but the workbook is still visible.

Please Login or Register  to view this content.

both codes above are able to hide my workbook, however, other workbooks are hidden as well. i suspect that the problem lies with "application" code.

[royUK]

The code that I posted is for the Userform, the clue is in

Please Login or Register  to view this content.

[dan2010]

hmmm. i tried your coding and it does not work.the workbook does not close. i tried putting the coding in "thisworkbook" as well as "userform".i believe that the "userform_initialize()" does not work for me.

[royUK]

The event works for any excel, the code also works.

Attach the workbook