Excel personal.xlsb import a form into without opening the Developer tab 1

[DougP]

I am writing custom forms for the company and wonder, is there a way to allow a user to import my forms into their Personal.xlsb file, without them having to show their developer Tab and mess with turning that all on? And on that note will a form work without having the developer tab turned on?
Having the Developer tab not show and have to turn it on then having to record a macro into the Personal .xlsb file to have it show is a lot for novice users. Its aggravating enough for me each time I have new install.


DougP

 

[SkipVought]

hi,

Your Personal.xlsb file is hidden. Yes a form, code et al can be imported into the personal workbook and run from any .xls* workbook, as the code is not in the .xls* workbook.

I never made forms, be I used to maintain a module for import into personal workbooks for user to access various data items from a variety of external databases, via functions that could be used on a sheet like any other built-in function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DougP]

Skip, so how did you import that or how did they, the manual way or did you give them a Personal.xlsb? I don't want to blow their existing away if they have something in it already.

DougP

 

[SkipVought]

I had each user import using this process.

1) alt+F11 - toggles the VBA Editor/Worksheet

2) ctr+R - view Project Explorer

3) right-click in PERSONAL.XLSB in Project Explorer and select IMPORT File...

4) drill down to the path/file you have provided

5) SAVE the PERSONAL.XLSB


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DougP]

Ok I created a VBS script file to launch Excel and Windows Explorer side by side.
If I can figure out a way to send Alt-F11 to Excel then I can have the person simply drag and drop the form from Explorer to the VBA Project window. so now they have to press Alt-F11
I know this is not VBA code its VBscript.

Set objExcel = CreateObject("Excel.Application")
objExcel.Application.Visible = True
Set objShell = CreateObject("Wscript.Shell")
strPath="My Documents"
strPath = "explorer.exe /e," & strPath
objShell.Run strPath
dim objShell
set objShell = CreateObject("Shell.Application")
objShell.TileVertically
set objShell = nothing

DougP