Forum Discussion
Marc_G2
Oct 13, 2023Copper Contributor
Can't run Form-Control-with-argument macro for no discernable reason
Update. I'm 99% sure the issue was somehow caused by me attempting to digitally sign my macro enabled document. I had done so repeatedly since I kept getting invalid signature errors. Clearing the...
Marc_G2
Oct 13, 2023Copper Contributor
The name of the module is something else. I've also tried moving the function to a different module which has no effect. And yes, I could use that as a workaround.
I'm thinking there might be a weird config problem or something might be corrupted. If go back to a much older version of the document, the problem isn't there.
I'm thinking there might be a weird config problem or something might be corrupted. If go back to a much older version of the document, the problem isn't there.
Marc_G2
Oct 13, 2023Copper Contributor
I created a copy of document and deleted everything except for the test function. I've also removed all library references. The issue persists...
- HansVogelaarOct 13, 2023MVP
Could you a copy of the workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Marc_G2Oct 16, 2023Copper ContributorHere's a link to the example. It's literally nothing but a button. It will mostly likely work fine on your system.
https://docs.google.com/spreadsheets/d/1gmWqB-GkCIXvjpyPaYACsK0k93NZv_KZ/edit?usp=drive_link
My IT support reinstalled Office to see if my install might be broken. It still didn't fix the issue. So now I'm now thinking it might be a config related bug.- HansVogelaarOct 16, 2023MVP
Thanks. The button works fine on my PC.
Could macros have been blocked on the PC where it didn't work?