Add-in Save permanent changes

[neodjandre]

Hello,

I have an add-in and I would like to have some variables that users can change via a userform and the values given will become permanent, so that they don't get reset when the user re-opens EXCEL.

any ideas on how to do that?

thanks
andy

 

[RoryA]

You could write them to a worksheet in your add-in and save the add-in.

 

[neodjandre]

thanks