I suspect there's a logical reason why you can't put workbook_open()
event code in the workbook you are trying to detect to do all the other
stuff... that would be easy
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"bigmart" wrote in message
ups.com...
Hi,
I'm not sure this can be done but I need to detect when a new workbook
of a given name (X) is created on Excel startup. If it is not that
workbook I need to continue as normal. If it is, I need to open another
named spreadsheet (Y), take sheet1 from the 1st spreadsheet (X) and
insert it after the last sheet in the other workbook (Y) and close (X).
I've been tearing my hair out trying to detect the name of the
spreadsheet (X) as Excel opens and haven't got any further than that.
Please help!!!
thanks
Mart