Save a customized user form as a default user form.

[Debraj]

I have created a customized user form.. nothing just company logo at top right and theme color for form.. and a company hyperlink.

Saving the frm file.. and import everytime is not a big task.. but.. just like sheet1 / book1..
is there any default location to save the frm file..
So that everytime Insert > User Form will load only that frm file..

PS..
got some idea..

Sub test()
  ThisWorkbook.VBProject.VBComponents.Import "D:\DOCUMENT\Desktop\UserForm1.frm"
End Sub

Still thread is open for actual query..

 

[Artik]

got some idea..

I think this is the right way.

Try these add-in from attachment.
Especially for you, Ninja

Password to vb project - one space
I build icons in Menu/Insert and Standard toolbar.

Artik

 

[Artik]

You must enable the option Trust Access to Visual Basic Project before installing add-in!!!

Artik

 

[Debraj]

Hi Artik,

Thanks for showing interest on this..
I just fall in love with the code..
The way you use the class module.. has a lots of things to learn..

Welcome to the forum.. and keep guiding..

PS: this site doesn't support GIF avatar.. it stopped flying here..