hide excel worksheet menu bar

jamienwood · Apr 26th, 2002, 05:52 AM

i would like to know how to hide the worksheet menu bar i want the file, edit etc to be hidden i have hidden the title bar, basically i want it so that users can only use the macros on the page to do everything!! i would also like to know how to hide the shhet title name at the bottom so i only have cells on the screen?????

Tom Schreiner · Apr 26th, 2002, 06:21 AM

Jamie,

Application.CommandBars("Worksheet Menu Bar").Enabled = False

Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 05:52 AM	#1
jamienwood Board Regular Join Date: Apr 2002 Location: Manchester UK Posts: 133	i would like to know how to hide the worksheet menu bar i want the file, edit etc to be hidden i have hidden the title bar, basically i want it so that users can only use the macros on the page to do everything!! i would also like to know how to hide the shhet title name at the bottom so i only have cells on the screen?????

Apr 26th, 2002, 06:21 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Jamie, Application.CommandBars("Worksheet Menu Bar").Enabled = False Tom