Freezing buttons or object whle scrolling rows/columns

EE Pros,

I have a set of buttons that I want to have stationary while the underlying columns and rows move.  In other words, as I scroll to the right, the buttons (or object) will stay in the same spot on the screen.

Hope this is rather easy since no macros should be involved.

Thank you in advance,

B.
moving-buttons-with-the-cells.xlsm
Bright01Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
you probably only can do this by setting the Freeze Panes at Cell C5...
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
byundtMechanical EngineerCommented:
You can achieve an effect similar to your request using a modeless userform. If the ShowModal property of the userform is set to False, then the userform will remain displayed while the user edits cells and moves around the worksheet.

The sample workbook will display the userform when the workbook opens to Sheet1 or when the user activates Sheet1. It will unload the userform when the user deactivates Sheet1. The two buttons on the userform call macros that display a Hello World message.
moving-buttons-with-the-cellsQ28721.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Bright01Author Commented:
Perfect.  Thank you Brad.

Ryan,  thanks for suggestion but that's how I had originally set it up..... it wouldn't work when scrolling over to the right.

Thanks guys,

B.
Bright01Author Commented:
Brad and Ryan,  Asking another question that is just like this but I need to know how to integrate the code I have into the model Brad provided.  The code I have is in the Worksheet under "My Code" and you can see there are two macros..... One that displays the status in an outline and the other is a simple return macro.

Much thanks.... hope one of you guys will pick the new question up.

B.
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
in Brad's sample file, just replace the scripts in sub Hello1() and Hello2() with the codes you want.

Option Explicit

Sub Hello1()
MsgBox "Hello World 1"
End Sub

Sub Hello2()
MsgBox "Hello World 2"
End Sub

Sub Modeless()
UserForm1.Show
End Sub

Sub CancelModeless()
UserForm1.Hide
Unload UserForm1
End Sub

of course, you can also rename the Sub to another name, just change that in userform's codes as well:

Private Sub CommandButton1_Click()
Hello1
End Sub

Private Sub CommandButton2_Click()
Hello2
End Sub
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.