Hi
in the Private sub for when a workbook opens I include the following code:
'developers tab
Application.ShowDevTools = False
'hide ribbon
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
'.................
'Hide formula bar
Application.DisplayFormulaBar = False
'..................
'max screen
Application.WindowState = xlMaximized
'..................
'do not show file history
Application.DisplayRecentFiles = False
'............................
The application I have built is driven from a sheet I use as a menu and the above disables certain user activity / views.
However during testing I have found that a user can right click on the "menu" sheet and still have access to the "insert" option. Though selection of this will not insert a sheet the application hangs and I cannot find a way to disable the "right click", not show "insert" or msgbox a msg to say don't .....
Can anyone help please?
many thanks
F0re5t
in the Private sub for when a workbook opens I include the following code:
'developers tab
Application.ShowDevTools = False
'hide ribbon
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
'.................
'Hide formula bar
Application.DisplayFormulaBar = False
'..................
'max screen
Application.WindowState = xlMaximized
'..................
'do not show file history
Application.DisplayRecentFiles = False
'............................
The application I have built is driven from a sheet I use as a menu and the above disables certain user activity / views.
However during testing I have found that a user can right click on the "menu" sheet and still have access to the "insert" option. Though selection of this will not insert a sheet the application hangs and I cannot find a way to disable the "right click", not show "insert" or msgbox a msg to say don't .....
Can anyone help please?
many thanks
F0re5t