-
Solved: setting scroll area in copied worksheet
I use Activesheet.Copy to create a copy of a worksheet.
However I want to set the scroll area in that new worksheet. When I code it after the ActiveSheet.Copy it works ok until I close the workbook and open it up again when the scroll area has not been saved.
Is there any way to put code into another workbook from code in the original workbook?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules