change the back stage title for excel on mac

CHANGE THE BACK STAGE TITLE FOR EXCEL ON MAC HOW TO
CHANGE THE BACK STAGE TITLE FOR EXCEL ON MAC CODE

I am trying to make it as simple as possible by giving them one choice so staff do not have to spend a lot of time answering questions about where to save a document.

You can also change the font size or the font itself if you don’t like the default one.

CHANGE THE BACK STAGE TITLE FOR EXCEL ON MAC HOW TO

How to Change The Font Size of Axis Titles. Options such as Skydrive - which can be removed, I know, but computer and add a place are still present. To format an axis title, click on it with the right mouse button, and use the quick formatting options panel to change for example, the background colour. You can disable backstage in the applications options, but this does not disable the options under File>SaveAs. A lot of our patrons get confused at this point as they are not familiar with any version of Office. When our patrons use Office 2013 and they go to the file menu, this launches Office Backstage - with a long list of options. RE: Comments after David's solution below:Įxplanation of what I am trying to accomplish. If I put it in the module, it comes closer to working, with the above problems.ĮXCEL-VBA Sub SaveAction(control As IRibbonControl) If I put it in 'This Workbook' I get an error about it not finding the 'SaveAction' macro.

CHANGE THE BACK STAGE TITLE FOR EXCEL ON MAC CODE

Even with the file in XLSTART when you close the document it also gives 'Microsoft Excel has stopped working.' so I need help.įinally, I have tried putting the VBA code inside 'This Workbook' in the vba editor, as well as creating a new module and putting it there. Move mouse to one of the corners of the chart or to the midpoints of chart borders until the mouse changes to a double headed white arrow, then you can. Then go to the Current Selection group, and select Chart Area by clicking the drop down arrow. If I hide the view to make them create a new page, then the customUI will not work. Click the chart, and click Layout tab (or Format tab). I tried putting the Excel macro enabled document in the XLSTART folder and while this makes it work on startup - users would be directly editing my workbook. I also need a way to make this work when Excel starts. I have pieced together some XML for the customUI that works for changing the backstage view, however, I cannot get the callback to VBA code inside the xlsm file to work properly. I intend to hide all of 'save' options in backstage and create a custom tab called 'Save Here' to remove this confusion. a Customer Name in the Chart title - when he 'filtered'. I work in a public library system and Office 2013 has created issues with our patrons saving files and I am trying to simplify the process. A viewer wanted my help to create titles in his Excel charts that dynamically updated to show - e.g.

Change the back stage title for excel on mac