DougRobertson
Active Member
- Joined
- Sep 22, 2009
- Messages
- 334
- Office Version
- 365
- Platform
- Windows
Hello,
When preparing a multi-sheet workbook to send, I'd like to have each sheet revert to the Top Left corner, and have cell A1 be active.
I tried Selecting all worksheets, then using
ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1
Range("A1").Select
but while the A1 select works this way, I have to open each sheet separately, then use the Scroll function.
Is there another way to do this?
Failing that, how do I activate each sheet one at a time, starting at the left tab, then working my way across to the right side?
Thanks in advance,
~ Doug
When preparing a multi-sheet workbook to send, I'd like to have each sheet revert to the Top Left corner, and have cell A1 be active.
I tried Selecting all worksheets, then using
ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1
Range("A1").Select
but while the A1 select works this way, I have to open each sheet separately, then use the Scroll function.
Is there another way to do this?
Failing that, how do I activate each sheet one at a time, starting at the left tab, then working my way across to the right side?
Thanks in advance,
~ Doug