Macro to adjust zoom percentage depending on users screen resolution?

Is it possible to write a macro that resizes a workbook so that in anybody's computer, whoever opens it can always see 100% of the screen width?

i.e. I have a workbook going from columns A to Q. In my view, I can see all the columns at once. Is there a macro I can write that, on opening the worksheet, alters the zoom percentage for each individual user so that column Q fits into their window?

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Thanks a lot, will test in a minute

What is the best way of ensuring this code runs as soon as each user opens the workbook?

I understand your point about not messing with other users settings - can you think of a way of ensuring the final column appears for all users without having to mess with their settings (there is important information in the final setting, but if their zoom is different, they may not realise its there, which may result in them using the rest of the information wrongly)