Hi all, so recently I've made some changes to a .xlsm Excel file and then digitally signed it.
I then opened the .xlsm Excel file and saved [CTRL + S] immediately without doing anything. An error message saying that "You have modified a signed project. You do not have the correct key to sign this project. The signature will be discarded. ..."
This is very puzzling as I did not make any changes to the macros at all between opening and saving the file. I'm trying to find out what is causing this issue and I've narrowed it down to these changes I've made before digitally signing the file:
(1) Resizing UserForm
(2) Changing RowSource Property of a Dropdown Control in an UserForm
(3) Changing the Caption Property of an UserForm
(4) Adding the code "Calculate" in my VBA Macros
I've also discovered some very weird behavior regarding UserForms
(a) Viewing the UserForm's interface in the VBA editor [either clicking View Object or just double-clicking the UserForm] automatically forces you to discard the Digital Signature upon saving even though no changes were made
(b) Somehow the UserForm keeps resizing on its own randomly and without warning, requiring me to manually adjust it via the VBA Editor
My own's guess is that by opening the .xlsm Excel file, the UserForm somehow got edited, causing Excel to conclude that I've modified a signed project while I have done nothing.
Anybody can help point me in the right direction, and possibly explain this error? Thanks a lot!
I then opened the .xlsm Excel file and saved [CTRL + S] immediately without doing anything. An error message saying that "You have modified a signed project. You do not have the correct key to sign this project. The signature will be discarded. ..."
This is very puzzling as I did not make any changes to the macros at all between opening and saving the file. I'm trying to find out what is causing this issue and I've narrowed it down to these changes I've made before digitally signing the file:
(1) Resizing UserForm
(2) Changing RowSource Property of a Dropdown Control in an UserForm
(3) Changing the Caption Property of an UserForm
(4) Adding the code "Calculate" in my VBA Macros
I've also discovered some very weird behavior regarding UserForms
(a) Viewing the UserForm's interface in the VBA editor [either clicking View Object or just double-clicking the UserForm] automatically forces you to discard the Digital Signature upon saving even though no changes were made
(b) Somehow the UserForm keeps resizing on its own randomly and without warning, requiring me to manually adjust it via the VBA Editor
My own's guess is that by opening the .xlsm Excel file, the UserForm somehow got edited, causing Excel to conclude that I've modified a signed project while I have done nothing.
Anybody can help point me in the right direction, and possibly explain this error? Thanks a lot!
