Hi Dave,

To replicate it perhaps create a new number format in your custom list
that is not included in the template used to open a new sheet.

Unfortunately the code didn't work.

I think the problem with what I am doing is that when the code runs
from the macro it opens a new worksheet from a template that doesn't
have the format as a custom format.

I have to post the spreadsheet out to many users so I don't think it is
practical to get everyone to change their templates.

Still it is strange that when I run the same command from the Excel
menu it doesn't lose the formatting...can't quite work that one out.

I wonder if there is some other way I can around it...?


Cheers

Tim


--
tmbo
------------------------------------------------------------------------
tmbo's Profile: http://www.excelforum.com/member.php...o&userid=37214
View this thread: http://www.excelforum.com/showthread...hreadid=569306