Thanks Bob,

All users was the best option. as it may not be used on my p.c.

Thanks again\

Greg
"Bob Phillips" wrote in message
...

Activeworkbook.SaveAs "C:\Documents and Settings\user\Desktop\" &
Range("A24").Value & ".xls"


replace user with your user name or even ALl Users.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg B" wrote in message
...
I am looking to have a workbook save using the name on a worksheet
called
"title" using cell a:24 as the name.

I also would like this to save to the desktop.

How would I do this please

Greg