Hi Excel Experts!
I wonder if I can have a macro code which will make some contents of my file be accessible (can be modified) to others if only the macro is enabled. I want to lock my file (all cells) to prevent others to change some of its contents. But since Microsoft disables the macro by default or asks the user to enable/disable the macro, I cannot leave my file unlocked.
I would like my colleague to enable it (macro) so that they can enter/modify the data of the selected cells from that file.
I hope you can help me with this. It really is a big headache for me because I do not have VBA background.
Thank you very much for your kind help.
I wonder if I can have a macro code which will make some contents of my file be accessible (can be modified) to others if only the macro is enabled. I want to lock my file (all cells) to prevent others to change some of its contents. But since Microsoft disables the macro by default or asks the user to enable/disable the macro, I cannot leave my file unlocked.
I would like my colleague to enable it (macro) so that they can enter/modify the data of the selected cells from that file.
I hope you can help me with this. It really is a big headache for me because I do not have VBA background.
Thank you very much for your kind help.
