+ Reply to Thread
Results 1 to 3 of 3

Make Shapes non-resizeabe and not moveable

Hybrid View

  1. #1
    Registered User
    Join Date
    06-28-2013
    Location
    China
    MS-Off Ver
    Excel 2003, 2010
    Posts
    4

    Make Shapes non-resizeabe and not moveable

    Hi All,

    I have several shapes on a page, and I want to make sure that the user will not be able to resize them or move them. I would be glad to render them un-selectable, but some of these shapes have macros assigned to them, so they will have to receive the click event.

    Thank you

    Dey

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Make Shapes non-resizeabe and not moveable

    Hi Dey,

    You can lock the objects and protect the sheet but then you may not click on them to run the macro.



    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    06-28-2013
    Location
    China
    MS-Off Ver
    Excel 2003, 2010
    Posts
    4

    Re: Make Shapes non-resizeabe and not moveable

    Thanks DILIPandey.
    That is the problem. quite a few number of the shapes have macros attached to them. Is there a way to have an event fire in case a shape is selected, or later deselected? That way I can check to see if their position or size has changed and reset them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1