I have changed the code as shown below. This works
Code:
Sub change() Call change_resolution(1280, 1024) End Sub
Sickbock
Last Activity: Oct 7 '13, 08:15 AM
Joined: Oct 4 '13
Location:
-
Thanks Rabbit for your help
I have changed the code as shown below. This works
-
Thanks Rabbit for your quick response. This was a little bit stupid indeed. But now I am immediately facing the next problem. When I write a procedure to call the function to change the screen resolution, the automatic fill up function of VBA wants me to add a sign of equality behind the expression "change_resolut ion(1280, 1024)". But I do not know what to add behind the sign of equality. I now put a x behind it, and the screen resolution...Leave a comment:
-
Changing screen resolution in Excel by VBA?
I have a computer that can manually be switched to 2 monitors. Both monitors do not have the same screen resolution. I am running a macro controlled presentation in Excel 2010 and I want to change the screen resolution when switching to the other monitor. In a previous post, “Change Screen Resolution using VB”, I found the following solution:
...Code:'************************************************* **************** ' DECLARATIONS SECTION
Last edited by Rabbit; Oct 4 '13, 05:58 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
No activity results to display
Leave a comment: