Hi I have a similar problem to groaner. On my page I have a command
button to open a user form for imputing and data and also a button to
save and close all my open workbooks. The problem I have is each time my
user form adds data to my worksheet I insert a new blank row at the top
of my sheet. This is so i dont have to scroll down to read the latest
data. Trouble is my command buttons are going down the sheet with my
data. Can I code them to stay at the top of my sheet?
Thank you for any assistance with this,
Cheers Lynn

Can't say I'm an expert, but what I do it set row 1 as a freezepane so it's
always at the top then put all my command buttons on that, that way you can
always view them where ever you are.

Hope that helps,

--
Dave


"Lynz" wrote:

Hi I have a similar problem to groaner. On my page I have a command
button to open a user form for imputing and data and also a button to
save and close all my open workbooks. The problem I have is each time my
user form adds data to my worksheet I insert a new blank row at the top
of my sheet. This is so i dont have to scroll down to read the latest
data. Trouble is my command buttons are going down the sheet with my
data. Can I code them to stay at the top of my sheet?
Thank you for any assistance with this,
Cheers Lynn

Oh, if you don't like that way, go into 'Format Control' then Properties and
select don't move or size with cells, that way, when you insert cells, it
doesn't move.


--
Dave


"Lynz" wrote:

Hi I have a similar problem to groaner. On my page I have a command
button to open a user form for imputing and data and also a button to
save and close all my open workbooks. The problem I have is each time my
user form adds data to my worksheet I insert a new blank row at the top
of my sheet. This is so i dont have to scroll down to read the latest
data. Trouble is my command buttons are going down the sheet with my
data. Can I code them to stay at the top of my sheet?
Thank you for any assistance with this,
Cheers Lynn

How about just putting the buttons in Row 1 (and freezing the window so that row
1 is always visible).

Then you add to the bottom (scrolling will still have row 1 visible).

Or just add your data starting in row 2.

Lynz wrote:

Hi I have a similar problem to groaner. On my page I have a command
button to open a user form for imputing and data and also a button to
save and close all my open workbooks. The problem I have is each time my
user form adds data to my worksheet I insert a new blank row at the top
of my sheet. This is so i dont have to scroll down to read the latest
data. Trouble is my command buttons are going down the sheet with my
data. Can I code them to stay at the top of my sheet?
Thank you for any assistance with this,
Cheers Lynn

--

Dave Peterson

Dave Peterson wrote:
How about just putting the buttons in Row 1 (and freezing the window so that row
1 is always visible).

Then you add to the bottom (scrolling will still have row 1 visible).

Or just add your data starting in row 2.

Lynz wrote:

Hi I have a similar problem to groaner. On my page I have a command
button to open a user form for imputing and data and also a button to
save and close all my open workbooks. The problem I have is each time my
user form adds data to my worksheet I insert a new blank row at the top
of my sheet. This is so i dont have to scroll down to read the latest
data. Trouble is my command buttons are going down the sheet with my
data. Can I code them to stay at the top of my sheet?
Thank you for any assistance with this,
Cheers Lynn


Thanks for the replies, Ill do some experimenting. I think I have had
trouble in the past with freeze panes. Possibly when the data was in
auto filter... cant remember at the moment but will try adding my data
to row 2. Thanks, Lynn

Dave Peterson wrote:
How about just putting the buttons in Row 1 (and freezing the window so that row
1 is always visible).

Then you add to the bottom (scrolling will still have row 1 visible).

Or just add your data starting in row 2.

Lynz wrote:

Hi I have a similar problem to groaner. On my page I have a command
button to open a user form for imputing and data and also a button to
save and close all my open workbooks. The problem I have is each time my
user form adds data to my worksheet I insert a new blank row at the top
of my sheet. This is so i dont have to scroll down to read the latest
data. Trouble is my command buttons are going down the sheet with my
data. Can I code them to stay at the top of my sheet?
Thank you for any assistance with this,
Cheers Lynn


Hi I found the solution to my problem, Knew there had to be a simple
solution some where. If I shift-right click the command button format
controlproperties and select"Dont move or size with cells" and now
button stays in same relative position on page and remains visible,
problem solved. Thanks to those who tried to help.
Lynn