??Floating Rows??

[Andy B]

Hi

Click on cell A2 and then go to Window / Freeze Panes.

 

[SlimPickins]

I would like to make row 1 float at the top of the sheet. This row has
30 columns and the user puts the wrong data in the wrong cells at
times. There are 650 rows, everyday about 3 rows are added.

Slim

 

[SlimPickins]

Thanks that is exactly what I wanted.

Slim

 

[Ken Wright]

You might also want to look at Data / Form to automate the additional entries
somewhat.

 

[SlimPickins]

Looking into the form thing ken thanks.

New Question:
Could I make a button float if it is "stuck" to a cell on the floating
row???

Slim

 

[Dave Peterson]

What does float mean now?

Does this mean move right or left (since you have that button on a frozen row
that won't move)?

If yes, you could use some code each time you change the selection:

rightclick on the worksheet tab and select view code. Paste this in:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim myShape As Shape
Set myShape = Me.Shapes("Button 1")
myShape.Left = ActiveSheet.Cells(1, ActiveWindow.ScrollColumn).Left
End Sub

Change "Button 1" to whatever name your button has.

You may want to look at creating a toolbar. You could position that where ever
you liked.

You could attach that toolbar to your workbook. If you want to look into this,
read these notes by
Jan Karel Pieterse:
http://google.com/[email protected]