"Alan R" wrote in message
...
or is there a way to have the value change on close


that question was answered, I believe, in a post by Gord earlier.

The macro needs to be posted into the "This Workbook" module not the
worksheet module ... so when you right click on the sheet tab and "view
Code", you need to then select the "this workbook" module before pasting
the sample code.

I believe there is a project manager pane open on the left side of the
screen by default that will show the different modules. If it is not
showing, check the options under the View menu.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)