Sigh... If you mean so the workbook will only open on one PC for one user, see here (but you're still wasting time - all these things are so easy to get round if you know how)
Sigh... If you mean so the workbook will only open on one PC for one user, see here (but you're still wasting time - all these things are so easy to get round if you know how)
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you![]()
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.