Avatar of Rayne
Rayne
Flag for United States of America 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
Microsoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
Rayne

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
dlmille

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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 :(
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck