Hi Paul

Change

Set Basebook = ThisWorkbook

To

Set Basebook = ActiveWorkbook


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Paul Sheppard" wrote in message
news:Paul.Sheppard.1t59r4_1122998748.9864@excelfor um-nospam.com...

Ron de Bruin Wrote:
Hi Paul

Run this macro one time
http://www.rondebruin.nl/summary.htm


Ron

Thanks for this, it works ok if I use it as a macro within the
workbook, so have solved my current problem

I have since copied the macro to personal.xls so that I could use it
again with other workbooks, the macro runs ok but i cannot see the
Summary Sheet when I run it this way, when I run it again on a new
workbook I get a message saying the summary sheet already exists in
this workbook, but I cannot see it and it is not a hidden worksheet

Any help greatfully received

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=392061