Posted by Stevie Windows on July 11, 2001 8:53 AM
I want to be able to insert a function into the Workbook_Open() subroutine that will discern what dimensions the viewer's monitor is set to, if the display is set to less than 1024x765: eg. it's set to 800x600, I want a message to flash recommending the user that the project is best viewed at 1024x765 or greater. Then I want the messagebox to offer the option "set monitor to 1024x765? Yes / No". If the user chooses Yes, I would ideally like to offer them the opportunity to set it back to the original resolution on closing the project. Any ideas??