Daily posts of Excel tips…and other stuff
Archive for the ‘Window Object’ Category.
When I do some screen shots, I need to hide the cursor. Not only do I want no cell selected, but I don’t want the column or row headers highlighted - so I can’t just page down for instance. Manually, I was using Ctrl+End to get to the last cell followed by a [...]
Right now I’m in the middle of closing out the month. That’s accounting lingo for reconciling the accounts and preparing financial statements. Most of my reconciling is done in one workbook with a worksheet for each account. The last sheet, titled AJE, is a list of my adjusting journal entries. (Oh [...]
If you’ve ever worked with more than one workbook, or even multiple windows per a workbook, you’ll probably have used Window arrangements.
You can arrange the windows by selecting Arrange from the Window menu.
With VBA you can arrange your windows using:
Windows.Arrange ArrangeStyle:=xlArrangeStyleTiled
Arrangements come in a few styles: xlArrangeStyleCascade, xlArrangeStyleTiled, xlArrangeStyleHorizontal, xlArrangeStyleVertical
For more control over your tiling, [...]
In the UI, you can arrange the open windows using Windows>Arrange. In VBA, the same effect is achieved using the Arrange method of the Windows collection object.
Application.Windows.Arrange xlArrangeStyleTiled
The argument is an xlArrangeStyle constant. What I haven’t been able to do is determine the current state of the windows. That is, there’s no [...]
