Hello,
I have been trying to find some VBA code (I am not a computer expert) that can allow me to force users to enable macros. Now, after researching, I know that it is not completely possible because it would make 'security' become useless. I also found codes for excel that hide the worksheets till macro is enabled or a password is used.
I also found a thread here but the document with the code is not available and only a hybrid version of it is still there (it was in 2007, and I believe Microsoft might have also made many changes) which is not of use to me.
Now, from this I know it is possible to create a VBA code such that it restricts editing/printing if the macros are disabled and a pop-up is displayed that asks the user to enable macro's for full access. Can someone help me get this code and also tell me how to implement it.
The reason why I am doing this is because I want to prevent copy-paste in the document but allow editing of it and also allowing copying and sharing of the document (as a file). The users are not tech experts but if they want to copy paste the document then I want to make it hard for them. I have also already used the 'restrict editing' thing to prevent editing of a few lines in the document. I have used the following codes but it requires enabling macros:
Sub EditCopy()
MsgBox "Copy is disabled."
End Sub
Sub EditCut()
MsgBox "Cut is disabled."
End Sub
Sub EditPaste()
MsgBox "Paste is disabled."
End Sub
Sub EditPasteSpecial()
MsgBox "Paste Special is disabled."
End Sub
Any solution is welcome. Thank you.