L
LiAD
Hi,
I have a code, (below), to hide toolbars and to prevent users from
tampering. I have a macro which performs some operations and then saves and
closes the file. I have just realised that the X to close excel on the top
right corner is still visible meaning the file can be closed without using
the macro. Is it possible to also hide this feature so users must close
using the macro?
Thanks
Private mFormulaBar
Private Sub Workbook_BeforeClose()
Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = True
Next oCB
Application.DisplayFormulaBar = mFormulaBar
End Sub
Private Sub Workbook_Open()
Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = False
Next oCB
mFormulaBar = Application.DisplayFormulaBar
Application.DisplayFormulaBar = False
End Sub
I have a code, (below), to hide toolbars and to prevent users from
tampering. I have a macro which performs some operations and then saves and
closes the file. I have just realised that the X to close excel on the top
right corner is still visible meaning the file can be closed without using
the macro. Is it possible to also hide this feature so users must close
using the macro?
Thanks
Private mFormulaBar
Private Sub Workbook_BeforeClose()
Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = True
Next oCB
Application.DisplayFormulaBar = mFormulaBar
End Sub
Private Sub Workbook_Open()
Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = False
Next oCB
mFormulaBar = Application.DisplayFormulaBar
Application.DisplayFormulaBar = False
End Sub