Allow Shape to be moved in Protected Sheet

[KarenJanes]

Hi
I want to protect a user input sheet but provide the user with a "guide" ie insert a shape that is a line, so that they can move the guide up and down to the row of data that they want to view or amend. What is the VBA to allow the shape to be moved?

 

[Peter_SSs]

Welcome to the MrExcel board!

If you are protecting the sheet with vba then try including the red text below in your protection code

... .Protect DrawingObjects:=False

 

[Peter_SSs]

Another option might be instead of having to physically move a line all the time to set the sheet up so that the row with the active cell always gets highlighted.
If that interests you, try adopting the row part of this.

 

[KarenJanes]

Welcome to the MrExcel board!

If you are protecting the sheet with vba then try including the red text below in your protection code

... .Protect DrawingObjects:=False

Great thanks - thats worked a treat

 

[KarenJanes]

Another option might be instead of having to physically move a line all the time to set the sheet up so that the row with the active cell always get highlighted.
If that interests you, try adopting the row part of this.

Yes this does sound interesting and preferable to moving a line up and down, but Im not sure that Im following the solution?!?

 

[Peter_SSs]

Yes this does sound interesting and preferable to moving a line up and down, but Im not sure that Im following the solution?!?

You would follow steps 1 to 6 of the linked post (post #4 in that thread), but omit step 3. If you get stuck on a particular step post back here with what step it is and what difficulty you are having.

 

[Peter_SSs]

Sorry, forgot to add that you would need to do the steps while the worksheet is unprotected, and then protect it again.

 

[KarenJanes]

Thanks Peter_SSs got that now.. it works a treat! Happy Holidays!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.