Keyboard Maps and Toolbars

[coswa]

In the near future, I'm going to distribute a macro to a large number of users. I'd like to have this macro ran from either a keyboard remapping or from a toolbar icon. I'd rather not have to this manually. Is there any way to do either of these with nothing more than VBA?

I'm planning on distributing via email an Attachmate macro and an Excel Add in that'll be installed with an excel macro that uses the workbook_open event to save these to the correct location and install the addin.


Thanks,
Chris

 

[boatbum]

Are you looking to actuall edit the users current keyboard or toolbar or can you just give them new EKM and ETB files?

 

[coswa]

I'm going to have to edit their existing keyboard maps or toolbars. Enough of them have customized settings that a new ekm file would be counter productive.