Enabled Macros to disabled copy paste but could just ignore Macros to enabled back

[chaiyya345]

Hi All,
I have found VBA code from (https://www.extendoffice.com/documen...opy-paste.html) to disabled copy paste, its working fine for a security reason.
However, if I just ignore to enable macros, I am are able to use copy paste which I feel not really secured. Any idea how to prevent this?

Please find attachment. Your help is greatly appreciated.

Thank-You very much

[TMS]

Excel is not a secure environment.

The only way to ensure that people enable macros and, therefore, your restrictions is to make the workbook unusable without enabling macros.

It's not a simple task although it is doable. You need to research excel vba force macro enabled

[jamfz]

I have a sheet that I think does what you are asking. it forces users to enable macros to continue and requires a worksheet named START that tells the user to enable macros to continue. it also makes sure they save it as a macro enabled sheet. Put this code ThisWorkbook.

Please Login or Register  to view this content.

[chaiyya345]

Hi TMS, jamfz,
Thanks for your help.

I have found simpler code to force enabled macros when opening worksheet.
Private Sub Workbook_BeforeClose(Cancel As Boolean)

I will close this thread & mark to SOLVED.

Thank-You very much

[TMS]

You're welcome. Thanks for the rep.


Glad you found a solution that works for you.