Hello,
I would like to have your opinion on the following problem. I have a number of the spreadsheets with some vba behind. I would like to implement some validation for all of them, for example connectivity to AS400 and SQL server, location of the spreadsheets (let us say they all must be on E drive) and some data validation such as 9 digits only for supplier codes (variables names are consistent for all of xls), etc. I wish to have validation coded in one place rather than been duplicated into multiple xls, so I could change/update it relatively easy. Any suggestions for possible implementation model? Your help/opinion is greatly appreciated. Thank you.