errorhandler

Ok...This one is a little tricky...at least for me it is. I have the code below which works perfectly fine until the user clicks to unlock, selects "yes" from the message box which uses Excel's "Unprotect Sheet" password prompt to request password and then clicks "Cancel". Below are the possible...

Hello all, I have some code that has a successful OnError code that provides a message indicating that the file is currently in use by another user (error code 75 would normally populate). What I am trying to do however, is put an if statement in the error code so that if the error isn't...

Hi, I am currently working on an Excel sheet with VBA that also opens a few other files in the routine etc. Now i was working on creating an ErrorHandler for the file but i ran into a problem where my "OriginalWorkbook" was no longer activated because i opened "WorkbookX" and an error would...

Hi everyone I'm new to VBA and I'm struggling to add an Error Message which is only shown, if there is no project in the slicer matching the users input. By now, the meassage is always shown, even if a matching project is found. Dim si As SlicerItem, fi As SlicerItem 'si item...

hey guys! tricky question, i have the following code that opens excel files in the folders i specify in the "files" sheet. some of the files are old and dont have certain sheets which i added in later versions. i added an errorhandler to deal with this issue, once an error occurs the subroutine...