stop a shape from scrolling with the screen?

merlin777

Well-known Member
Joined
Aug 29, 2009
Messages
1,397
Office Version
  1. 2007
I want to place one or more buttons made from drawing shapes at the top of the screen but keep them there when the screen scrolls sideways - is this possible?

I know I can freeze some columns but this would mean freezing more screen than is practical.

tia
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Right-Click on the button, and select "format properties" -- you will find what you want there...
 
Upvote 0
that's what I thought but deselecting those radio buttons doesn't stop it scrolling with the columns...
 
Upvote 0
Except maybe you freeze the columns and ensure they are to the left of the frozen columns
 
Upvote 0
I've got half a screen's width of buttons can't really freeze half a screen...
 
Upvote 0
Next choice is to put them on a userform.
 
Upvote 0
i'm liking the sound of both of those...

1. how do you stop a user form from scrolling with the screen?

2. can you point me at a good tutorial for floating toolbars?
 
Upvote 0
1. You don't have to. They sit still unless you move them.
 
Upvote 0
2. No I don't have a link to a tutorial, but they are called CommandBars and the controls on them are CommandBarControls.
 
Upvote 0

Forum statistics

Threads
1,222,227
Messages
6,164,723
Members
451,912
Latest member
HMF009

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top