Hi Thanks for your response. The menu buttons aren't there either way. I have tried some other things I found on google, e.g.checking whether Worksheet menu bar was enabled and visible, and VB returns true when I ask this in the Immediate window. The only thing I can think of is that it's hiding off screen, because the locations when I ask what the Left and Top settings are, were both -8 (whatever that means). It is unfortunately beyond my VB knowledge to rearrange menus programmatically. When I press ALT and V/E/O/R etc. all I hear is a system sound and nothing happens.
In the meantime I have got around the issue by creating another user profile and that was unaffected. I also found out while doing that, that user settings are now kept in the cloud, so that would explain why repeatedly deleting my .xlb file wasn't working. I deleted my settings using my Microsoft account, but they say they will remain there until they do a periodic cloud clean-up, which they haven't done since it's still not working. This is not an ideal solution, however, as it's a pain having to maintain 2 logins to do different things.
Any help would be much appreciated. Cheers