Looking for the code to center worksheet based on monitor size

[lnagel]

anyone already have the worksheet centering code that works no matter what the monitor size - that would be willing to share?

Also want to lock current worksheet size (make current size the full screen size). Thanks in advance

 

[lnagel]

Getting 1004 Error saying "unable to set .Width" - on the .Width = 1450

Typically I get 1004 when trying to modify a protected worksheet. Added the unprotect - same result

 

[footoo]

It works for me without error.
See if this helps : https://www.google.com.hk/search?q=....69i57j0l5.16676j0j8&sourceid=chrome&ie=UTF-8

 

[lnagel]

DOH - So the 1452 is not correct - It is actually largwer than Screen Size - I need to get my numbers right and I think Im good - Thanks for hangin in there with me on this

 

[lnagel]

Yep - Works Perfect with the right numbers