You could add it to the workbook_Activate event and unhide it in deactivate

Private Sub Workbook_Activate()
if not fAlwaysShown Then
Application.CommandBars("Worksheet Menu Bar").Enabled = False
End If
End Sub

Private Sub Workbook_Deactivate()
Application.CommandBars("Worksheet Menu Bar").Enabled = True
End Sub

and have the same code to unhide in the button macro, but create a global
variable fAlwaysShown and set that to true when the password is entered..


--

HTH

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


"ditchy" wrote in message
ups.com...
Hello there,
would there be a way to hide the Worksheet Menu Bar for one particular
workbook only, and have a macro button to unhide the Worksheet Menu
Bar after a password is entered,
(and not affect all the other workbooks Worksheet Menu Bars)
thank you for any help or suggestions
Ditchy