save state of a custom checkbox on ribbon

Hi there,

I think you'll need to save the state of the Checkbox somewhere in your workbook (cell, named constant etc.) and then, when the workbook is opened, invalidate the Checkbox to set its state in accordance with the stored value.

Hope this helps.

Regards,

Greg M

you can save that in the registry

Thanks for your response.

You can also save the value in a 'Built In' or 'Custom' Document Property.

For example:

Please Login or Register  to view this content.

See the file associated with post #4 in the following thread for a working file that contains the above code: http://www.excelforum.com/excel-gene...tact-info.html

In Excel 2016 you can see the properties: File > Info > Properties (top right) > Advanced Properties

Lewis