Save a Boolean Variable and Recall Later

I have a workbook which has a macro that runs when it's open. Currently, it sets the auto complete feature to False, but I want it to check if the value is true or false and then set it to false. Later on the user of the workbook will run a macro and I want that macro to recall the boolean value and set it back to what it was originally. How can I do that?

You can always assign the outcome to a single cell somewhere in your workbook and call on its value later.

perhaps using a public variable...

See links for explanation

http://www.ozgrid.com/VBA/variable-scope-lifetime.htm
http://support.microsoft.com/kb/141693
http://www.cpearson.com/excel/scope.aspx

Or the built-in document variable like Subject, Author, etc.

Workbooks(1).BuiltinDocumentProperties("Subject") = MyValue