Floating Shape

[Jonathan78]

Hello all,

The following code allows shapes to "float".
The user has to select a cell somewhere on the screen though.
This works all great, but I need to protect my sheet, and then it will not work any more.
Is there a solution with the scrollbar or something

Please Login or Register  to view this content.

I know that you can make a userform do all this, but I really need a shape in this case
All help is welcome

[shg]

What code ?

[Jonathan78]

I edited my post

[shg]

Please Login or Register  to view this content.

You pay a heavy price for using that, IMO -- it kills Undo.

[Jonathan78]

Thanks for trying but it didn't work
(protects the sheet but nothing more)

[shg]

Works fine for me. You need to change the password in both lines.

[Jonathan78]

Not for me
Thanks for your help though!

[shg]

That's not very helpful feedback.