Citrix Delivered Macros to Excel - help

[kellyvw]

I am trying to deliver 2003 Excel Macros to users on a Citrix delivered system. The macro is designed with icons that appear on the toolbar, when I deliver the macros all the VBA comes across successfully but not the icons, does anyone have any ideas?

 

[Hermanito]

Do you supply the macro's as an addin?

How did you create the icons in the toolbar? Did you add icons in existing toolbars or create a specific new one? The Excel via Citrix might be configured that changes to standard toolbars are reset/deleted with every startup.

Do you create/enable a toolbar in the workbook_open event?

 

[kellyvw]

Hi thanks for your reply. No the macro is a .bas that I load into VBA, once loaded I added the icons via Customise onto the tool bar then took the personal.xls and deployed this to the other users. This was the same method to how I deployed a similar macro for Word and that worked fine.

 

[BarCodeWiz]

The toolbars are not stored within the add-in, like in Word. You will have to recreate them.

 

[kellyvw]

Hi BarcodeWiz

When you recreate them is that for each individaul or can it be done in bulk across all users? Thanks

 

[Hermanito]

The standard method goes something like this:

for an add-in:
in the AddinInstall handler, you put code to create your toolbar and add its buttons
in the AddinUninstall handler, you delete your toolbar

for a workbook, the same steps but now respectively in the
Workbook_Open and Workbook_BeforeClose handlers.

That way, the toolbar gets created when a user has your addin installed, or your workbook opened, and you clean up when the addin gets uninstalled, or your workbook is closed...

 

[kellyvw]

Many thanks for the feedback, this worked for my 2007 Add-in but not the 2003 Macro is there something I can do for 2003 Excel

 

[BarCodeWiz]

Hi kellyvw,

Is there an error message? What exactly isn't working? Does the event not fire, etc?

 

[Hermanito]

I use that method in Excel 2003 and it works fine for me, can you show us your code, and indicate where it fails in 2003?

 

[kellyvw]

I don't believe the code fails as such, just that when I deploy it via the personal.xls to all citrix users the Icons on the toolbar don't appear even though it is part of the Master Toolbar. The code is there when I check via the Tools/Macro and I can find it to move it to the toolbar but I am wanting the personal.xls to do this for me. I am happy to copy in the code but I'm not sure if it is needed.