m.zaeim
09-06-2017, 01:05 PM
hi.. i wanna know how can i have table and charts of a sheet Full screened and FITTED (in every size of monitors ) when i click on the button1 ..
i have used this code but it didn't work properly
ActiveSheet.UsedRange.Select
ActiveSheet.ChartObjects.Select
Application.DisplayFullScreen = True
ActiveWindow.Zoom = True
i have used this code but it didn't work properly
ActiveSheet.UsedRange.Select
ActiveSheet.ChartObjects.Select
Application.DisplayFullScreen = True
ActiveWindow.Zoom = True