Opening a User Form

[MacroNoob]

Hey Guys,

I have a file that i use at work, where i run a macro and a user form is then brought up on screen. i then fill it out and it transfers everything to my file correctly. The only thing is, i want this form to open automatically the first time the file is open. We have other workbooks like this at work, where the user form pops open the first time you open the file, and never again after that. But, i just cant seem to figure out how the programmer did it. Can anyone help??

[mudraker]

It sounds like there is a Workbook_Open() or a Auto_Open() macro int he workbook
This macro would have commands to show the form when the workbook is opened & then possible deletes some code or adds some code to prevent the form from showing again or even possible deletes the form.

Without seeing these other workbooks it is very hard to know how they are setup.

[teebird]

Here is a copy of a spreadsheet that I found on the net. All credit to whoever design it.

You may find it useful for what you want to do.

Cheers
Tee