If I insert the following in a module ("ScrSize") in Personal.xls, what is the code to return the ScreenWidth value for use in another VBA Project?
MD

[VBA]
Private Declare Function GetSystemMetrics Lib "user32.dll" (ByVal nIndex As Long) As Long
Const SM_CXSCREEN = 0
Const SM_CYSCREEN = 1
Public Function ScreenWidth()
ScreenWidth = GetSystemMetrics(SM_CXSCREEN)
End Function
Public Function ScreenHeight()
ScreenHeight = GetSystemMetrics(SM_CYSCREEN)
End Function

[/VBA]