Trapping error in add-in

Hi all,

I have created an add-in with multiple module and intended to use as password protected file.

Since there are multiple modules and there are multiple opportunity of errors. Is there is any way I can trap errors by declaring any thing as global or using class programming which can help to generate error message and exit the procedure in case any error arise during any execution.

Thanks,
Govind

Hi,

I am expecting run time errors such as type mismatch, user do not enter correct values. code error due to transition from workbook to add in..

Most recently i have seen error in this part of code of adding hyperlink.
(still trying to figure out sol)
ActiveCell.Hyperlinks.Add Anchor:=mycell, Address:= _
"XXXXXXX", TextToDisplay:=original

I am looking for a solution where user get a generic error message such as "unable to process" etc. when any such error occurs.

Thanks,
Govind

Thats for sure!!
I have tried to use that as much possible (with my limited knowledge of VBA).

Some of the errors such as I mentioned above are occuring in the utility.where code is working fine in the worbook..but do not work when i use it as add-in..
see the above example of hyperlink. It is working fine when i use in original workbook. but it gives error when i use in add-in.


govind

above error was occuring because the worksheets were shared and that caused the error...


Govind