replacing menubar

slim · Mar 18th, 2002, 03:15 AM

help!

how can I make sure that the normal excel menubar is replaced with a custom one called hospital?

I thought this would work

Set mybar = CommandBars.Add("hospital", msoBarTop, True, True)
mybar.Visible = True

but it throws up a runtime error
'object variable or with block variable not set'

I have included
Dim mybar As CommandBar
at the top of the code

any advice?

andy

Dave Hawley · Mar 18th, 2002, 03:20 AM

Hi Slim

I have a detailed example of this sort of thing here:

http://www.ozgrid.com/VBA/ExcelWorkbookEvents.htm

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

Mar 18th, 2002, 03:15 AM	#1
slim New Member Join Date: Feb 2002 Posts: 42	help! how can I make sure that the normal excel menubar is replaced with a custom one called hospital? I thought this would work Set mybar = CommandBars.Add("hospital", msoBarTop, True, True) mybar.Visible = True but it throws up a runtime error 'object variable or with block variable not set' I have included Dim mybar As CommandBar at the top of the code any advice? andy

Mar 18th, 2002, 03:20 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Slim I have a detailed example of this sort of thing here: http://www.ozgrid.com/VBA/ExcelWorkbookEvents.htm