ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA password prompt workaround (https://www.excelbanter.com/excel-programming/445375-vba-password-prompt-workaround.html)

John Smith[_17_]

VBA password prompt workaround
 
Hi,
I'm having a problem with the VBA password prompt appearing when I
close out of Excel. I've seen numerous posts about this issue and am
curious about some of the stated fixes for it. If it's simply a
question changing a registry key, then why doesn't MS default it to a
different number? Or is it possible to change the key using VBA? I
don't understand the MS workaround (KB280454) referencing the
ActiveX.dll. They seem to make out to be a more involved issue then
simply having a sharing problem with Google. Any help would be greatly
appreciated. Thanks.
James


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com