Userform to Open with Microsoft Spreadsheet

[Ardiko]

Hi guys,

I need my UserForm to start when I open the spreadsheet? Anyone know how to do this?

Excel Headings Problem - Macro V10.xlsm

Any help would be greatly appreciated.

[mshale]

To have the userform open when the workbook is opened, the following code must be place in the ThisWorkbook object (open this section by double-clicking the ThisWorkbook item in the Project pane on the left ofthe VB editor window). This will open that section, and then just paste the code there.

Please Login or Register  to view this content.

[Ardiko]

Thanks for your help!

[Mowgli]

Ardiko,

The code also works if placed in a module and called. Do you want the form to open everytime you open the workbook or when there are certain criteria, like only open on the first time?

[Ardiko]

Mowgli,

I want it to open everytime I turn on the excel sheet but I want to be able to deselect and select the form with ease. At present if I want to change anything on the excel sheet I have to close it down and re-open it. Is there a way to simultaneously run both? Ultimately I want to make it a stand alone form that I can alter a excel sheet with.

I've attached the sheet if you have time to have a look.

Excel Headings Problem - Macro V10.xlsm

[Mowgli]

Ardiko,

The simplist way is to have a button which calls the form when you want it. I have attached one in the Sheet and put the CallForm macro in Module 6. It uses the same command as the Auto Open when Excel starts.

I notice you have a Headings button still on the sheet, so assume you are happy working with buttons. I used a Form Control button instead of ActiveX as my machine has been playing up with ActiveX controls when cells are hidden and then unhidden however if you prefer ActiveX then you could write the code into the button instead of having it call a separate piece of code.

Excel Headings Problem - Macro V10 Rev A.xlsm

[Ardiko]

Thanks Mowgli for the help! I have only recently started to work on this project again. +Rep