A
Andy B
Hi
Click on cell A2 and then go to Window / Freeze Panes.
Click on cell A2 and then go to Window / Freeze Panes.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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
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
S
SlimPickins
Thanks that is exactly what I wanted.
Slim
Slim
K
Ken Wright
You might also want to look at Data / Form to automate the additional entries
somewhat.
somewhat.
S
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
New Question:
Could I make a button float if it is "stuck" to a cell on the floating
row???
Slim
D
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]
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]