-
Notifications
You must be signed in to change notification settings - Fork 322
When using RDVBA and code signing within Access VBA the signature will be discarded if RDVBA Loads #6295
Description
Rubberduck version information
The info below can be copy-paste-completed from the first lines of Rubberduck's log or the About box:
Rubberduck version (tested with several, and with 2.5.92.6381 mostly)
Operating System: Win11
Host Product: MSAccess
Description
When loading RDVBA in the VBAIDE (not even running to parse, simply loading RDVBA), the HelpFileName variable will be reset from time to time by RDVBA. This resets the VBA Code Signature and causes mayhem, much weeping and knashing of teeth because the dev doesn't realize what's happening.
Disabling RDVBA from loading during VBAIDE startup appears to fix this issue.
Realizing I know the variable is used to track RDVBA instance, fixing this may be a bit of a doozie, but it's quite frustrating.
To Reproduce
Steps to reproduce the behavior:
- Open VBA IDE.
- Sign Code with Code Signing Cert.
- (Optional) restart Access. Your code should run as if signed.
- Open VBA IDE.
- If it is not loaded, Load the RDVBA Addin.
- RDVBA will load.
- Save the VBA IDE. This appears to be optional; but will make it more likely to happen.
- Restart Access.
- When restarting the program, you will likely become frustrated that you have done nothing, changed nothing, and your code won't run because the code signature is not valid / has been tampered with.
- You will, after much consternation, discover that actually, RDVBA set an instance pointer w/ the
HelpFileName. - Disabling RDVBA from autostart upon loading of the VBAIDE will cause this behavior to stop, because the
HelpFileNamevariable is no longer shifting.
Expected behavior
Loading the VBA IDE and RDVBA does not cause you to chase something else. AKA: doesn't cause signature tampering.
Screenshots
n/a (for now).
Logfile
Rubberduck generates extensive logging in TRACE-Level. If no log was created at %APPDATA%\Rubberduck\Logs, check your settings. Include this log for bug reports about the behavior of Rubberduck.
Additional context
Add any other context about the problem here.