Addin - Separate Data tab to have Refresh and Submit in different tabs

Hi Nuno,

You can create your own button and add it to the Onestream Tab.  I just did  a quick and dirty to show you. Create the macro for OneStream function first, then add the macro to the OneStream tab. See print screens below. I tested it and it works for me. I hope you get this to work. It's a nice feature that can be useful sometimes when end-users use a lot of Exel 🙂

1. Create the Macro - To refresh the Active Worksheet

2. Add it to the OneStream tab - Under Options and then Customize Ribbon

First create a New Group and then Rename it to the name you want (in my case Customized). Then add the macro under your new group and save it.

3. The result- Clicking on the new button will refresh the active worksheet

Here are the other macro syntaxes:

From 6.6.0:  triggering data submission of XFSetCells with an Excel macro is now possible. The new VBA function is 'SubmitSetXFFuntions'.

Peter