E
ECF1956
I developed a form that needs two versions of the first page to cover
different circumstances. The form has links to other worksheets (pages
in the form) to eliminate the need to re-enter the same data on them. I
have a macro to change the version of the form. The macro deletes the
first sheet and replaces it with one of the two versions; it then
renames the worksheet to the original name. The problem is that the
link references are changed and therefore error out. Is there so way to
prevent these links from changing their link references. If they would
not change; my macro would work.
different circumstances. The form has links to other worksheets (pages
in the form) to eliminate the need to re-enter the same data on them. I
have a macro to change the version of the form. The macro deletes the
first sheet and replaces it with one of the two versions; it then
renames the worksheet to the original name. The problem is that the
link references are changed and therefore error out. Is there so way to
prevent these links from changing their link references. If they would
not change; my macro would work.