SharePoint Jedi

Fredd

<div>
<div class="content wysiwyg-content">
I have an Access Report which background VBA code displays for the users in Print View (only). &nbsp; Users do not see the left hand navigation bar - everything is managed for them via forms/buttons, etc. <br />
I need to restrict them from exporting the report data to excel in the print preview of the report. <br />
I don't mind they can export to word or PDF - but a solution involves hiding those as well, that's ok. <br />
users need to see the ribbon on forms to sort records, filter, etc. <br />
<br />
I guess I could hide the ribbon entirely on that print view using report_load (to hide the ribbon) and report_close ( to restore the ribbon) <br />
any thoughts on this &nbsp;is there a way to hide the export to excel button (and &nbsp;perhaps others?0<br />
Environment Access 2016 , Windows 7/10
</div>
</div>


I have an Access Report which background VBA code displays for the users in Print View (only).   Users do not see the left hand navigation bar - everything is managed for them via forms/buttons, etc. 
I need to restrict them from exporting the report data to excel in the print preview of the report. 
I don't mind they can export to word or PDF - but a solution involves hiding those as well, that's ok. 
users need to see the ribbon on forms to sort records, filter, etc. 

I guess I could hide the ribbon entirely on that print view using report_load (to hide the ribbon) and report_close ( to restore the ribbon) 
any thoughts on this  is there a way to hide the export to excel button (and  perhaps others?0
Environment Access 2016 , Windows 7/10

MS ACcess - hiding export ribbon buttons

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.