Press Alt+Q to return to the worksheet.Select any cell and scroll down or across and select any other cell, and as you do that, the picture object will always be in the upper right corner of the screen. Width - ActiveSheet.Shapes('PictureX').Width - 45ĪctiveSheet.Shapes('PictureX').Top =. Top + 5ĪctiveSheet.Shapes('PictureX').Left =. Right click on that sheet tab, left click on View Code, and paste this into the large white area that is the worksheet module: Private Sub Worksheet_SelectionChange(ByVal Target As Range)ĪctiveSheet.Shapes('PictureX').Top =. Select any worksheet cell to deselect the PictureX object. Click inside the name box (just to the left of the formula bar) and enter “PictureX” (without the quotes) and then press Enter. Select the option “As shown when printed” and click OK.Īctivate the sheet where you want this table to always be visible.Īt that point, the range is a picture object on your desired sheet, and that picture object is selected. With that range selected, press the Shift key, and while doing that, from the worksheet menu click Edit > Copy Picture.
Select the range of data which represents the table you want to keep visible.
