RobbieC
Active Member
- Joined
- Dec 14, 2016
- Messages
- 376
- Office Version
- 2010
- Platform
- Windows
Hi there, I have a macro button in my custom Ribbon Menuto go to a worksheet (Project) which has the following code:
This works fine.
What I would like is for the vba code to center in on a range (H2:K2) so that this page is always in the center of the screen, no matter what size the users monitor/window is. I have provided enough 'empty columns' either side of my range so that it can be 'scrolled' into position...
Is this possible?
Thanks
Code:
Sub ProjectInfo_button(control As IRibbonControl) On Error Resume Next
With Worksheets("Project")
.Activate
End With
End Sub
This works fine.
What I would like is for the vba code to center in on a range (H2:K2) so that this page is always in the center of the screen, no matter what size the users monitor/window is. I have provided enough 'empty columns' either side of my range so that it can be 'scrolled' into position...
Is this possible?
Thanks