Problem with random code generation

Hi!

I have two files. One file contains products (Product.xls) and another file (Requests.xls) contains information about customers which select product with randomly generated code. When I input data in new row all OK. But if I add new column excel automatically recalculate randomly generated codes.

Please help me to correct this issue.
All files attached.

I use function Static_RAND :

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here