Lock Objects over Freezed Panes

Rayne
Rayne used Ask the Experts™
on
Hello,

I have a question regarding Locking the objects over freezed cells - The object and the checkboxes are also set to [Don’t move or size with Cells] as well but that doesn’t seem to work…whenever I move over the bottom bar to the right, the object and the checkboxes within the object also move with that. How to stop that ensure even if I am moving to the right, those objects don’t move – they stay still over the freezed panes as you see. Also the objects have to stay at their current location (around the freezed panes) because of limited space.
LockingShape-Buttons.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2012
Commented:
Scrolling around with freeze panes, unfortunately, doesn't imply that objects will stay fixed as you "split" the screen via that scrolling.

You could ensure that that object and controls contained therein are in the upper left quadrant of your screen (not in freeze pane territory) so that the cells where they reside aren't affected by your scrolling.

The only other possible way I can think of is to create a modeless dialog box with these objects in them, hovering over the portion of the screen where you want them to show up.  Then, as you move around the screen, the objects stay in place.

Dave

Author

Commented:
Thank you Dave, I will keep that in mind. Finally I came across a excel limitation I guess :)
When you have  time, you can demo me the possibility as I have never made modeles box before.
Most Valuable Expert 2012
Top Expert 2012

Commented:
Here's a sample modeless form.  Hit the button on the worksheet, then you'll note you can click and move around in your workbook and the form always stays where it appears (unless you move it).

Note the command:

UserForm1.Show vbModeless 'make it modeless as opposed to default, vbModal (which forces you to respond before you can do anything with Excel)

For positioning userforms to other locations than default, see:

http://www.cpearson.com/excel/formposition.htm

Dave
sampleModelessForm-r1.xls

Author

Commented:
Perfect!! Dave,

Atleast I have a option now :) Thank you. Something can be done now. I thought I was stuck with the limited space :(

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial