(Solved) – How to disable shape copy paste with vba in worksheet

(solved)-–-how-to-disable-shape-copy-paste-with-vba-in-worksheet

i have few flowchart shapes in excel sheet. which i use for label designing purpose. but i don’t want to allow user to copy paste selected shape object in same worksheet.

i tried following.

Application.copyObjectsWithCells = False

Application.CutCopyMode = False

But above lines doesn’t seems work. how can i disable copy paste for shape still allowing to edit and design textframe character text.
Help is appreciated. Thank You.

Leave a Reply

Your email address will not be published. Required fields are marked *