I have an application with one workbook acting as a user interface and another hidden workbook that contains all the data. Because of bad planning on my part there is a sheet in the UI book that really should be in the other workbook.
This leads me to the problem that should I move the sheet, then there will be very many macros that are referencing that sheet incorrectly. Rather than go through every macro and correct them to update the link, I wondered if there was another, quicker way that anyone may have used?
I hope that is clear!
This leads me to the problem that should I move the sheet, then there will be very many macros that are referencing that sheet incorrectly. Rather than go through every macro and correct them to update the link, I wondered if there was another, quicker way that anyone may have used?
I hope that is clear!