Workbook Open to 100% of any screen size

[adste89]

I have a large monitor so when I make a page on excel and others open it, it's much bigger on theirs.

I'd like to be able to run a macro that looks at their screen size and fits it 100% (and go full screen but I already know the code for going full screen)...

Any ideas?

[JosephP]

you might try

Please Login or Register  to view this content.

[adste89]

That doesn't work...just zooms into a very small range (so it looks huge)...and only applies to one sheet.

[JosephP]

it zooms into whatever the used range of the sheet is. if that's not what you asked for what did you want?

[adste89]

Hi thanks for looking into this. The used range I guess means the range of "things" on that sheet? If so I have text boxes and graphs from A1:AF50 but it zooms into something like D1:G10

[adste89]

p.s. I am currently using the following code to maximise the workbook.

Please Login or Register  to view this content.

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[adste89]

...there you go

[JosephP]

if it's a fixed range you can specify that

Please Login or Register  to view this content.

for instance. usually easier in my opinion to design for a lower base resolution instead of making your users squint ;-)

[adste89]

How would I get that to apply to all sheets rather than just the active sheet?

[JosephP]

is it the same range for each sheet? if it is a simple loop should work

Please Login or Register  to view this content.