Custom button builder Excel 07

[Klemen25]

Hello

On datapig site there is a useful builder for buttons in E 07.
http://www.datapigtechnologies.com/freeware.htm

I tried to use it but I get an error:

Run time error »1004«
Method 'VB project' of object '_Workbook' failed.

In VB it than marks the line:
Set VBComp = ThisWorkbook.VBProject.VBComponents.Add
(vbext_ct_StdModule)

Did anyone try this? Have some solution. Otherwise a great site and
useful to check!

 

[Ron de Bruin]

I not try it but I think this is your problem

In the VBA editor, go the the Tools menu and choose References. In that dialog, scroll down to and check the entry for Microsoft
Visual Basic For Applications Extensibility 5.3
Next, you need to enable programmatic access to the VBA Project. In Excel 2003 and earlier, go the Tools menu (in Excel, not in the
VBA editor), choose Macros and then the Security item. In that dialog, click on the Trusted Publishers tab and check the Trust
access to the Visual Basic Project setting.

I also have one old builder on my site
http://www.rondebruin.nl/ribbon.htm

See RibbonX tips


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




Hello

On datapig site there is a useful builder for buttons in E 07.
http://www.datapigtechnologies.com/freeware.htm

I tried to use it but I get an error:

Run time error »1004«
Method 'VB project' of object '_Workbook' failed.

In VB it than marks the line:
Set VBComp = ThisWorkbook.VBProject.VBComponents.Add
(vbext_ct_StdModule)

Did anyone try this? Have some solution. Otherwise a great site and
useful to check!

 

[Klemen25]

Great!
It started to work after following your instructions.
I will check your site also!

All the best.