ok ill try that when im at work &Â let you know.Any results?
im confused the workbook i use every day at work is the one i sent you last,If your environment at work is 64-bit, then that workbook can not work there. If you read the error message you got running my xyz workbook, you'll see that it's telling you that it needs to be updated to 64-bit. Since I didn't change anything in the workbook you downloaded except to rename it xyz.xlsm, that workbook can not be your work workbook.
Option Explicit
Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwnd As Long) As Long
which will cause the same error you got above.- a question, if i add, edit or delete an item in this wksht while at home, then bring to work, will i have any problems?If you mean that, say, you delete or change the data in the workbook and then you replace your work workbook with the one you just changed, then no, you won't have any problems.
- so why does this now work and all this time it has not?Two reasons: 1) Â we were working with the wrong workbook much of the time, and 2) I don't have 640bit so I could not test my changes.
- only thing is it possible to add the 'open last search' feature into the form?Please ask a new question.