Forum Discussion
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...
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?
Here'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.
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.
Thanks. The button works fine on my PC.
Could macros have been blocked on the PC where it didn't work?
- It's definitely not the case of them being blocked. Buttons work just fine as long as I'm not also trying to pass an argument.
I tried running a repair on the document and Excel said it fixed some errors. It didn't fix the problem though.I doubt we'll ever know what causes the problem...
