asked on

Lock Objects over Freezed Panes

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

ASKER CERTIFIED SOLUTION

dlmille

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rayne

ASKER

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.

dlmille

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

Rayne

ASKER

Perfect!! Dave,

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