How to change resolution of monitor/screen

  • Thread starter Thread starter Glen Mettler
  • Start date Start date
G

Glen Mettler

I want to give the user an option to change the resolution of the monitor
(800x600 - 1024x768) etc.
Is there a code I could use to do that? (using Excel 2000)


TIA
Glen
 
Your best bet may be to let the user do it through the Windows user
interface. You can pop open the Display Properties dialog like this:

Sub a()
SendKeys "^{Pgup}"
Shell "rundll32 shell32,Control_RunDLL desk.cpl"
End Sub

The purpose of the SendKeys is to switch to the Settings tab of the dialog.
It works for me but is never completely reliable. I haven't found another
way to open the dialog to this tab but that doesn't mean there isn't one.
 
Back
Top