Since you don't say what "doesn't seem to work" means, it's hard to
tell. Is nothing happening? the wrong value being entered?

The code should be entered in the ThisWorkbook module of the XLT. The
XLT should have the target cell blank when saved.

In article . com,
"Ken Zenachon" wrote:

Well, I did as you said but it doesn't seem to work.
Am I supposed to save the worksheet as an XLT template or should just
opening the XLS file with the code in the ThisWorkbook module do the
trick?