Hello to you all,
I thought I join the conversation.
You could try to desactivate the Delete Sheet from the edit Menu and the contextual menu [right clicking the worksheet tab name].
But that will only works if the macros are allowed to run.
My idea is to hide all sheets apart from copyright sheet with written on it :
Macros needs to be enabled in order to use the worksheet.
When your code is good, set all sheets to veryhidden excepts copyright sheet and password protect the vba projects for viewing.
Protect the vba project with a password so the code can't be removed or changed.
In the workbook open set other worksheets to visible
ie: code
''Sheet 3 is the copyright, Delete Sheet will be inactive when Sheet 3 is activate.
''Sheet 4 is another sheet
Code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
'ie sheet4 is set to hidden on close
Sheet4.Visible = xlSheetVeryHidden
End Sub
Private Sub Workbook_Open()
'sheet4 is set to visible on open
Sheet3.Activate
Sheet4.Visible = xlSheetVisible
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.CodeName = "Sheet3" Then
enableDelete (False)
Else
enableDelete (True)
End If
End Sub
Sub enableDelete(deleteIt As Boolean)
Excel.CommandBars("edit").Controls("De&lete Sheet").Enabled = deleteIt
Excel.CommandBars("Ply").Enabled = deleteIt
End Sub
You may want to try if this can help to secure more your workbook.
The solution of course is not 100 % fiable.