Create the user form shortcut without open Excel workbook. Does it possible?

Hi guys.

I have created an inventory system where the user needs to fill the user form in order to make IN and OUT transaction. Then the macro will automatically update the balance quantity of that particular items in the database.

But i try to look on something new where the user doesnt need to open the Excel workbook at all in order to update the transaction. Maybe it can be like an independent program in the dekstop ? So,the user just need to click open the program. Maybe only the authorized person will only open the real workbook once they got something to do with the database.

Does it sounds possible? if yes, how?

Thanks in advance for answering.

Hi -

In your thisworkbook open event, put

Please Login or Register  to view this content.

but you need to control the application in your form, to close it properly. And also, if the user did not enable the macro then your workbook is still open.
unless your security is set to Low (not recommended).

on you can create a blank visible sheet that the user can see if they did not enable the macro

Regards,
Event

dear event21,

What do u mean by "this workbook open event" ?

Sorry but i'm so naive as i have no idea where to plug in the code. Does it in the user dorm code or in the separate module?

Hi -

From the Project Explorer to the left.

Regards,
Event