asked on 5/21/2012

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

Microsoft Office Microsoft Excel

Last Comment

Rayne

5/21/2012

ASKER CERTIFIED SOLUTION

dlmille

5/21/2012

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Rayne

5/21/2012

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

5/21/2012

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

5/21/2012

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 :(