Floating Toolbar

D

Dave

Hi All

Is there a way to have a floating toolbar in say Sheet1 and one in Sheet2
with different names and they only show up in there own sheet.

Thanks in Advance

Dave
 
B

Bob Phillips

Hide it and make it visible in the worksheet_Activate event

Application.Commandbars("myBar1").Visible = True


--

HTH

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