rmk
asked on
Access 2013 (32 bit) Backstage Windows 7 (64 bit)
I have an row in USysRibbons that basically hides the backstage except for the print tab.
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<backstage>
<!-- Info -->
<tab idMso ="TabInfo" visible="false"/>
<!-- New -->
<tab idMso ="TabOfficeStart" visible="false"/>
<!-- Open -->
<tab idMso="TabRecent" visible="false"/>
<!-- Save -->
<button idMso="FileSave" visible="false"/>
<!-- Save As -->
<tab idMso="TabSave" visible="false"/>
<!-- Print -->
<tab idMso ="TabPrint" visible="true"/>
<!-- Close -->
<button idMso="FileCloseDatabase" visible="false"/>
<!-- Account -->
<tab idMso="TabHelp" visible="false"/>
<!-- Options -->
<button idMso="ApplicationOptionsD
</backstage>
</customUI>
I also have a report that is opened in preview mode as a dialog report from VBA. The report has it's own custom ribbon that only contains the close preview button. The report also has a short cut menu that only allows close. In other words this report can never be printed per my client's specification. My problem is that when the user clicks the File tab on the report's custom ribbon, the Print feature is exposed. How to I disable the backstage Print or make the backstage print invisible only when this report is open in preview mode?
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<backstage>
<!-- Info -->
<tab idMso ="TabInfo" visible="false"/>
<!-- New -->
<tab idMso ="TabOfficeStart" visible="false"/>
<!-- Open -->
<tab idMso="TabRecent" visible="false"/>
<!-- Save -->
<button idMso="FileSave" visible="false"/>
<!-- Save As -->
<tab idMso="TabSave" visible="false"/>
<!-- Print -->
<tab idMso ="TabPrint" visible="true"/>
<!-- Close -->
<button idMso="FileCloseDatabase" visible="false"/>
<!-- Account -->
<tab idMso="TabHelp" visible="false"/>
<!-- Options -->
<button idMso="ApplicationOptionsD
</backstage>
</customUI>
I also have a report that is opened in preview mode as a dialog report from VBA. The report has it's own custom ribbon that only contains the close preview button. The report also has a short cut menu that only allows close. In other words this report can never be printed per my client's specification. My problem is that when the user clicks the File tab on the report's custom ribbon, the Print feature is exposed. How to I disable the backstage Print or make the backstage print invisible only when this report is open in preview mode?
ASKER
I'm not sure I understand your comment. That's exactly what I have in my backstage xml in my rbnBackStage row in USysRibbons. I have another row for rbnForm. As far as I know you cannot mix the 2 in 1 row of U.SysRibbons
Have you tried adding the <backstage> sections to your custom Report ribbon?
I've never had the need to completely remove the Backstage stuff ...
I've never had the need to completely remove the Backstage stuff ...
ASKER
Like I stated earlier, I don't think you can add backstage sections to custom report ribbon.
Can you post a sample database with your ribbon stuff in it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See Gunter's article here:
http://www.accessribbon.de/en/index.php?Access_-_Ribbons:Ribbon_XML___Controls:Backstage_View
Essentially, you would include XML like this in your Ribbon code:
<backstage>
<button idMso="FileSave" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
etc etc
</backstage>