I suspect you'll need to do this with VBA. You'd turn on the toolbar when
the worksheet is activated and turn if off when it's not. I've linked some
code that may work.

http://www.bygsoftware.com/Excel/VBA..._menu_demo.htm


"Wei" wrote:

I have five worksheets in one workbook. I try to make a tool bar just for the
one worksheet(name is class) and is only visible when the "class" sheet is
active?
Thanks!