How to disable Page View buttons (Normal, Page Layout, Page Break View) next to Zoom on status bar

[ACommandLineKindaGuy]

Amazing how impossible it is to phrase this search on Google... I'm not interested in manipulating or viewing page breaks. All I want is to be in normal view.

I am not interested in workarounds similar to attaching

If ActiveWindow.View <> xlNormalView Then ActiveWindow.View = xlNormalView

to some event.

I want to either disable or hide these buttons.

TIA John

 

[Fluff]

Right click the status bar & uncheck "View shortcuts"

 

[ACommandLineKindaGuy]

Thanks! I didn't know about that right click functionality.

However, this is an excel setting, meaning it applies to all workbooks and not just the active one.

So how do I uncheck shortcuts and disable the status bar using vba for just the active workbook?

 

[Fluff]

Not sure you can, I'm afraid.

 

[Jaafar Tribak]

Interesting question.

Is there a way of displaying the statusbar right-click context menu via vba ?

Something similar to CommandBars("Cell").showPopUp

If there is a way , I guess we could use the MSAA to turn off/on its elements.

Regards.