Macro that will adjust to a user screen resolution, once file is open.

Looking for a code that will automatically adjust to a users screen resolution, once they open up the Excel file. What I have already is:

Please Login or Register  to view this content.

[QUOTE=gmr4evr1;4276266]I tried it in a blank workbook and changed 100 to true and it worked as expected.[/QUOT

Liked I stated above, I've tried the True function also, and it registered no difference. I sent 2 Test pages to a friend, Test and Test2. Test had the 100 and Test2 had the True. Both returned the same exact look on the screen.

I think Excel 2013 do not behave in the same way as Excel 2010. Take a look at this youtube video

https://www.youtube.com/watch?v=lA3e0u5JGEY

Alf

Originally Posted by JapanDave

You can use the Windows API to do this.

Please Login or Register  to view this content.

I've saw this code online, but I really don't understand how to use it. I've copied and pasted it into the VBA editor, but i never saw any difference. Maybe I'm using the code wrong. I need this code, incorporated, with this code, below:

Please Login or Register  to view this content.

How do I implement my code with your Windows API code?

Originally Posted by JapanDave

OK, try this,
Edit, sorry I did not see your last posts code.

Please Login or Register  to view this content.

I tried the code out, it didn't work, BUT could it be because i'm only trying it on my system? I've been trying it on my laptop, which is, 1366 x 768. I drop my screen resolution to 1024 x 768 to see the difference. Question is, is it because i'm trying it on my own system and not another?

Originally Posted by JapanDave

It should not matter what resolution the screen is. You do want it at 100% correct?

Yes, correct, i do want it at 100%. I noticed when I put my screen resolution to 1024 x 768 that a lot of the right side is still cut off.

Originally Posted by JapanDave

Can you go into Visual Basic editor > View > open Intermediate window for me.

Than put this code in a standard module and step through it with F8.
Then can you tell me the value in the intermediate window of "mW" and "z"

Please Login or Register  to view this content.

Would it be better if i just sent a test file?

Originally Posted by JapanDave

I want to see what your PC spec is.

I only see Immediate window, not a Intermediate window

Originally Posted by JapanDave

I want to see what your PC spec is.

Ok, disregard the last message. When I followed what you said, the number that came up was 1311

Originally Posted by JapanDave

Than, it should be working fine. BTW, adjusting the screen resolution won't do anything for making Excel 100% zoom. Can you manually adjust the the zoom to 50% in "EXCEL" and then run this code.
Then tell me if excel went back 100% zoom.

Please Login or Register  to view this content.

I manually adjusted the excel file to 50%, first before entering the code. Than, I entered the code, then saved the file. When I re-opened the file, the file stayed at the 50% zoom.

Originally Posted by JapanDave

No, I need to to run the code I just posted while the file is open. Paste in a normal module in the VB editor, click run/play ,go back to the sheet you just adjust to 50% and tell me if the window is back to 100% zoom.

The window did go back to 100% after i just tried what you stated.

Originally Posted by JapanDave

If that is the case, you workbook on open even is not working. Can you post the workbook without sensitive data?

I just tired the file I've been working on. I dropped the zoom percentage to 50%, then I saved the file. I re-opened the file up, and it opened up at 100% zoom. This is the code i was using:

Please Login or Register  to view this content.

Originally Posted by JapanDave

So does that mean you are getting the results you need? If so mark the thread solved and don't forget to give reputation to those who helped you.

Dave

I have to make sure, this Monday, how it will open up on a friends computer, first. They have Excel 2010, because my main goal was to see if it can be adjusted on other computers besides just mine.

Originally Posted by JapanDave

So does that mean you are getting the results you need? If so mark the thread solved and don't forget to give reputation to those who helped you.

Dave

So far, what I've noticed is that this code seems to work perfect on other laptops, but when it's being viewed on monitors, with different size screens, their's still parts of the worksheet information that's being cut off. I made this file on a 15.6" screen laptop.