Hello
I need to provide extra security to a password locked file. For this I have a suggestion with Password locked VBA macro code for Sheet named say `SheetX’. In `SheetX’ in particular cell say `X500’ if some particular text say `ABC1234XYZ’ is there then all should be visible in the `SheetX’, if no text `ABC1234XYZ’ is there in cell `X500’ of `SheetX’ then all (Texts and Formats) should be hided in `SheetX’.
Also if saved, closed and re-opened the file then the macro should automatically clear the entry of `ABC1234XYZ’ is there in cell `X500’ of `SheetX’.
So the inputs in password locked macro will be
Sheet name : Say `SheetX’*
Cell # in `SheetX’ : `X500’
Text in Cell X500 : `ABC1234XYZ’
Password for vbcode : `ABCD@1234’
All these above 4 inputs should be entered only one time in VB Code and it should not prompt to enter when opening .xlsm excel file every time. Except password which needs to be prompt for enter when vb code required to change.
Thanks in advance
Sekar
Bookmarks