How to remove 'System' menu in toolbar Excel for Mac 2011

[MervynG]

Hi,

Opened a spreadsheet relating to room accommodation for my son on a school trip and a new drop down menu appeared in the toolbar entitles 'system'. I assume it relates to Visual Basic and some macro. However, the spreadsheet does not appear to have any macros and as I have no access to the original source and server I am unable to remove this.

Any advice on how to get rid of this unwanted toolbar very welcome.

Thanks

Mervyn

 

[MervynG]

Hi Jon

Finally got there but ...

when I paste your text in the Immediate Window an error pop up appears:

Run-time error '5':

Invalid procedure call or argument

 

[Jon Peltier]

Sorry, I haven't used CommandBars in years, and Excel 2011 in many months. This is what you need to type into the immediate window:

For i = 1 to 2 : CommandBars(i).Controls("System").Delete : Next

 

[MervynG]

Sorry Jon, It throws up the same error.

Mervyn

 

[Jon Peltier]

That error means it's not finding the item to delete.

Type this into the immediate window and press Enter, then copy the next line exactly (which VBA produces in response) and include it in a reply:

? "|" & CommandBars(1).Controls(1).Caption & "|"

 

[MervynG]

|X|

 

[Jon Peltier]

That's bizarre. It says the first menu is Excel ("X"), even though the System menu is visible there.

And I suppose this doesn't help:

View menu > Toolbars > Customize Toolbars and Menus
Select Worksheet Menu Bar > Reset
Select Chart Menu Bar > Reset

I'm afraid I don't know how to clean up your menu bars.

 

[MervynG]

Hi Jon,

You do, you just didn't realise it! I'm not sure which one as I did both in quick succession, but its finally gone. Thnak you.

 

[Jon Peltier]

Let's hope it stays gone!