G-Man Screen Resolution
Posted by Damien on July 24, 2001 7:00 PM
Very nice little macro should do what i'm after didn't know that you could return the value of screen resoultion from user 32 file I suppose that you can if you can change it but having problem getting it to run what do you mean by the Workbook_Open module is that the Auto_Open module or are you referring to the Thisworkbook excel object or was it a class module ?
Anyway I get a error from
Declare Function GetSystemMetrics Lib "user32"_(ByVal nIndex As Long) As Long
error: Public members of object modules
any ideas returning setting from the user file is just getting a little advanced for me understand exactly what it is doing a stuff but have done little of it my self the zoom idea is good but depending on the system settings