+ Reply to Thread
Results 1 to 3 of 3

How to protect shapes from being inadvertently moved by user

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    9

    How to protect shapes from being inadvertently moved by user

    I did create a group of two shapes. One square and one circle. The main reason behind grouping them is to have them rotate around the same centre.

    Now the problem of the usage of the shapes. I don't want them inadvertently shifted by the user. The rotation of the circle will be wobbly.

    The circle is rotated by a module. Protecting the sheet makes the rotation of the circle stop working.

    My thought was to overlay part of the sheet by an Active X label and set the BackStyle to transparent and there is no need to protect the whole sheet.

    The problem now is that when I click on the label it turns white, and as soon as I move the cursor out of its perimeter the "underlying" circle will become visible again.

    How to prevent this behaviour of the label. I want the label to stay invisible and protect the underlying shapes from being moved.

  2. #2
    Registered User
    Join Date
    10-28-2013
    Location
    amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: How to protect shapes from being inadvertently moved by user

    I read this in a thread from 2005 by dlh.

    Unfortunately there is no final answer nor do I really understand if the drawing objects brought the solution

    Quote Originally Posted by dlh View Post

    The functionality I want seems fairly simple: I want a (semi-)fixed label with transparent background on top of a picture embedded within an Excel sheet. The user should not be able to change this label. How can it be done?



    Transparent background of ActiveX control

    Is that a textbox from the Control Toolbox?

    What about from the Drawing toolbar.


    That said all the various containers will turn the background white whilst editing them, if that is what you mean by semi-fixed.



    transparent background of ActiveX control

    Thank you! I was being very dense. Drawing objects are a much better choice than ActiveX Labels.
    Last edited by faraoosiris; 02-06-2014 at 06:48 AM.

  3. #3
    Registered User
    Join Date
    10-28-2013
    Location
    amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: How to protect shapes from being inadvertently moved by user

    [SOLVED]

    The scrollbar is used to rotate the group. On the background of the scrollbar I created a TextBox.

    In the on MouseMove property of the TextBox I have written a code to call a module that unprotects the sheet on approaching the boundary of the TextBox. Leaving the same area calls the module to unprotect the sheet.

    Furtermore I created a free form shape that overlaps almost the entire area accept for the cells that are used to create an input on the form. There is a hand pointer when moving over this shape and when the user accidentally clicks it calls the same module to protect the sheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How To Move Shapes From Another Shapes? (floating shapes)
    By MarcLev in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2009, 04:04 PM
  2. Moved workbooks to folders now User form "Subsript out of range"
    By cheelie in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-01-2008, 06:51 PM
  3. [SOLVED] How to protect shapes in Excel
    By mslava123 in forum Excel General
    Replies: 1
    Last Post: 05-24-2005, 05:06 PM
  4. Macro Error when moved Xcel Sheets from User's Home Dir to Networ
    By Basheer in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-29-2005, 12:06 PM
  5. Replies: 2
    Last Post: 01-06-2005, 11:06 PM

Tags for this Thread

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