Peo Sjoblom's vba works great!

One last request.

What formula would you recommend to show only the workbook name &
worksheet name in a cell (A3 or whatever) separated only by a hyphen -
. For example for a workbook named Payroll with a sheet named Rates:

Payroll-Rates

Thanks a million. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=482983