L
LantzK
I have a worksheet that is adding data on sheets between two anchor sheets.
When a user wants to examine specific sheets I have an input box asking which
sheets they want to look at and then am using the move.worksheet before and
after to move my anchor sheets. This works fine usually but when certain
sheets, the ones at the beginning of the workbook are chosen after the code
is run my totals sheet has had it's formulas changed. usually reads
sum(blank:template!a1) to say (january:template!a1) if the january sheet is
chosen. Can anyone explain as to why this is happening? Nothing in the code
is referencing this page while the code is running.
When a user wants to examine specific sheets I have an input box asking which
sheets they want to look at and then am using the move.worksheet before and
after to move my anchor sheets. This works fine usually but when certain
sheets, the ones at the beginning of the workbook are chosen after the code
is run my totals sheet has had it's formulas changed. usually reads
sum(blank:template!a1) to say (january:template!a1) if the january sheet is
chosen. Can anyone explain as to why this is happening? Nothing in the code
is referencing this page while the code is running.