hide/change color of selected row headings

  • Thread starter Thread starter Joe Smith
  • Start date Start date
J

Joe Smith

Is it possible to hide the row heading numbers for
selected rows (i.e. rows 51 and greater) for just the
selected sheet? I'd like to have a color with no row
heading number appear that matches the fill color I select
for the adjacent cells.

Secondly, any ideas as to how I can prevent the user from
scolling further down than a certain point (i.e. row 51).

Thanks in advance.
Joe
 
Row headings are either on or off, you can't hide some. However, you
can achieve a similar effect by hiding *all* headings
(Tools/Options/General) and putting the numbers 1:51 in A1:A51.

to limit scrolling, put this in your ThisWorkbook code module
(right-click on the workbook titlebar and choose view code):

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "1:51"
End Sub

Unfortunately, the setting is only saved for the session, hence
needing to use an event macro.
 
Back
Top