AhmedMatboly
10-13-2022, 06:28 AM
I like that forum and i was so newbie since one month ago and this forum was my way to start
I faced the problem of how to force users to enable macros and stop them from misuse the sheets before macro run
And i want share this method its newbie method but maybe its useful for someone
U protect the sheets with password for all users then after macro run the workbook event will unprotect sheet with sheet1.unprotect then the macros will run as u want then in beforeclose event will sheet1. protect so the another user who didnt enable macro will find sheets protected and will be forced to enable macro i think its not good method as splash sheet method but it was easier to me and less buggy
I faced the problem of how to force users to enable macros and stop them from misuse the sheets before macro run
And i want share this method its newbie method but maybe its useful for someone
U protect the sheets with password for all users then after macro run the workbook event will unprotect sheet with sheet1.unprotect then the macros will run as u want then in beforeclose event will sheet1. protect so the another user who didnt enable macro will find sheets protected and will be forced to enable macro i think its not good method as splash sheet method but it was easier to me and less buggy