vba_monkey
Board Regular
- Joined
- Dec 18, 2013
- Messages
- 112
Hello,
I have a macro which creates a new spreadsheet and saves as .xlsx. Among many other formatting tasks, one of the things the macro does is to set the scroll area to the used range on each tab.
This all works perfectly but the only problem is, once the workbook has been closed and reopened, the scroll area has been deleted.
How do I get excel to save the scroll area?
I have a macro which creates a new spreadsheet and saves as .xlsx. Among many other formatting tasks, one of the things the macro does is to set the scroll area to the used range on each tab.
This all works perfectly but the only problem is, once the workbook has been closed and reopened, the scroll area has been deleted.
How do I get excel to save the scroll area?