Microsoft Excel 2013 Programming by Example With VBA, XML, and ASP

Author:Julitta Korol
Language: eng
Format: mobi
Tags: XML, VBA, ASP, Computing, Programming, Computers, Excel, Spreadsheets, Desktop Applications, Excel 2013, Internet
ISBN: 9781938549915
Publisher: Mercury Learning & Information
Published: 2014-02-15T02:00:00+00:00

In the Visual Basic Editor window, activate the Project Explorer window and double-click the ThisWorkbook object in the Microsoft Excel Objects folder under VBAProject (Practice_WorkbookEvents2.xlsm).

In the ThisWorkbook Code window, enter the Workbook_WindowResize procedure as shown below. Private Sub Workbook_WindowResize(ByVal Wn As Window)

If Wn.WindowState < > xlMaximized Then

Wn.Left = 0

Wn.Top = 0

End If

End Sub

The example procedure moves the workbook window to the top left-hand corner of the screen when the user resizes it.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.