Storing a value in a variable for use at a later date.

Hello again,

I have an Add-in that creates and formats reports for various users.

Within the add-in I have rules set to disable some buttons on a userform untill a process is run to enable them. I am doing this through the use of a variable - set as "0" untill such a time when the process is run that it will set the variable to "1". A function is then run to enable all of the buttons.

However, once excel is shutdown and re-openned - it resets the variable to "0" for no apparent reason. Is this normal? Is there a way around this - so that the Add-in remembers what the variable was set to before closure?

Appreciate your help! Neil

I thought that was going to be the case!

As its an add-in I dont have a workbook open, so wouold probably go with the text file to store the variable, but not sure how I would do this - and how I would pick this back up when re-openning the add -in?

Thanks

The add-ins are going to be installed on individuals PC's though - and I want the indicater recognised by all.

So I think the text file would be best - but not sure how you would reference a text file to store and to re-establish once open?

Thanks

Excellent - thanks for your help.

Just out of curiousity - how does the Print #fnum part of the code work? This doesn't seem to be set as a variable, yet it still works.

Tried looking it up in the help - but cant find anything: