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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dell Optiplex graphics driver failure 2
determining resolution of current screen display 2
Detect Monitor Resolution in Windows 7 'not tworking' the way I wantit to for monitor resolutions 1
List box problem - from monitor resolution 9
How to Display UserForm on Full Screen. 1
Screen Resolution 9
Ultrawide vs Dual Monitors 32
ViewSonic VP16-OLED Unboxing: High-End Portable Monitor Designed for Creators 2

Back
Top