I think the first place that anyone thinks to look is the very hidden
sheet option. The name is harder to find, many users would not even
think of it.
The other option would be the Registry, but that means it would work on
a different computer. You could also write to a text file.
None are foolproof though
--
royUK
Hope that helps, RoyUK
For tips & examples visit my 'web site' (
http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile:
http://www.thecodecage.com/forumz/member.php?userid=15
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=101883