Try
ActiveWindow.DisplayWorkbookTabs = _
Not ActiveWindow.DisplayWorkbookTabs

Signature
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"gti_jobert"
>
> Hi all,
[quoted text clipped - 4 lines]
>
> Thanks all.
gti_jobert - 28 Feb 2006 15:34 GMT
Cheers boss, have got it working with your help now!

Signature
gti_jobert