Afternoon All,
I have just noticed the new version of excel 365 that when I open my database it shows the quick access toolbar.
Because I dont want anybody mucking around with the database I was wondering is there a code to either disable/hide the quick access toolbar from showing when the database is open.
I have a few codes that I have used previously such as
But this does not give me Application.DisplayQuickaccess = False Or is there a way in Custom UI to disable it Can anyone shed some light into this please. Is there a code where I can disbale Quick access toolbar? Thanks Steve
Yes Thanks Anders,
It looks like I cant but I can disable the all the buttons relating to the Quick access tool bar.
For example SAVE AS:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim xName As String
xName = "CancelBeforeSave"
Application.ThisWorkbook.Worksheets("TitlePage").Activate
Range("A1").Select
If SaveAsUI Then
MsgBox "Save As is disabled", vbInformation
Cancel = True
End If
End Sub
Or email or other buttons that relate to the workbook.
Anyway thanks for the help
