ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error Message at Launch (https://www.excelbanter.com/excel-programming/377876-error-message-launch.html)

[email protected]

Error Message at Launch
 
Is there a way to stop an error message at the open of a workbook? The
message is occuring before it gets into the VBA code. I've handled
what needs to get fixed in the code, but I'd like to prevent the users
from seeing the first message.

More detail is that I'm launching something through AssemblyName and
AssemblyLocation, but the location can vary from pc to pc. So, they
code checks for the new location and updated. If I click OK through
the message, I can then make the updates if needed. It's just not
pretty... :)

Any ideas?


JLGWhiz

Error Message at Launch
 
What is the error message?

" wrote:

Is there a way to stop an error message at the open of a workbook? The
message is occuring before it gets into the VBA code. I've handled
what needs to get fixed in the code, but I'd like to prevent the users
from seeing the first message.

More detail is that I'm launching something through AssemblyName and
AssemblyLocation, but the location can vary from pc to pc. So, they
code checks for the new location and updated. If I click OK through
the message, I can then make the updates if needed. It's just not
pretty... :)

Any ideas?




All times are GMT +1. The time now is 10:29 AM.

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