Rlb53
02-19-2012, 01:05 PM
Good Morning, Afternoon , Evening (as the case may be?)
The "Auto-Open" Macro of my workbook provides for a selected area to view on the Main Sheet.
Application.DisplayFullScreen = True
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayHeadings = False
Application.DisplayFormulaBar = False
' scroll_stop Macro
Sheets("Main").Select
ActiveSheet.ScrollArea = "a1: u28"
ActiveSheet.Protect
Is there a command that will automatically adjust the zoom according to the Monitor settings so that the selected area is centered on the screen?
As I open the workbook on different computer systems I find that the screen settings alter the view.
I have a code generated that will call for and assist the user to Zoom the screen settings upon activation of the workbook, (not shown) but if it could be done for them without interaction, it would be more appealing.
----------
I would also like to deactivate the "Restore Down" and "Close" buttons at the top right of the screen. I require that they use the "EXIT" command button on the workbook sheet to perform processes prior to being closed.
Thank you for your Thoughts.
The "Auto-Open" Macro of my workbook provides for a selected area to view on the Main Sheet.
Application.DisplayFullScreen = True
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayHeadings = False
Application.DisplayFormulaBar = False
' scroll_stop Macro
Sheets("Main").Select
ActiveSheet.ScrollArea = "a1: u28"
ActiveSheet.Protect
Is there a command that will automatically adjust the zoom according to the Monitor settings so that the selected area is centered on the screen?
As I open the workbook on different computer systems I find that the screen settings alter the view.
I have a code generated that will call for and assist the user to Zoom the screen settings upon activation of the workbook, (not shown) but if it could be done for them without interaction, it would be more appealing.
----------
I would also like to deactivate the "Restore Down" and "Close" buttons at the top right of the screen. I require that they use the "EXIT" command button on the workbook sheet to perform processes prior to being closed.
Thank you for your Thoughts.