Design of the Excel VBA Password Changing Module

摘要

In this paper, we design a module that can change password when Excel VBA password is set. Especially, we designed it to be applicable to VBA environment using macros in Excel. It often happens that you cannot access important file data due to password loss, after setting the VBA password. For these users, it is possible to access valuable data by more convenient VBA password using the proposed program. We actually implemented the proposed design in this paper. Experiments were performed on the actual contents of the excel file. Experimental results show that the contents of Excel VBA password can change.