I want to be able to create an Excel spreadsheet (version 2003 or newer) from a macro in a parent Excel spreadsheet.
I then want the macro to put the following code into the Sheet1 Worksheet_Activate module:
[login to view URL] = xlLandscape
[login to view URL] = [login to view URL](0)
[login to view URL] = [login to view URL](0)
[login to view URL] = xlPageBreakPreview
[login to view URL](1).DragOff Direction:=xlToRight, RegionIndex:=1
The purpose is to have the child spreadsheet be automatically formatted correctly when it is opened.
Your task is create both spreadsheets plus the macro in the parent spreadsheet.
If you have any questions, please ask before you bid.