+ Reply to Thread
Results 1 to 2 of 2

Help locking group boxes so they don't move but buttons inside still work

  1. #1
    Registered User
    Join Date
    11-05-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    47

    Help locking group boxes so they don't move but buttons inside still work

    So I've finished the electronic SSQ I've been creating and with all the help from you guys on here it turned out great. I was polishing everything up and I just can't seem to get my group boxes to lock correctly. The user needs to be able to select one of the radio buttons in the box of course but even when I set the group boxes to Locked and protect the sheet you're still able to right click and move them around. Anyone know a way to force the group boxes I have in place to stay in position? Another issue I came across was with trying to lock/protect the sheet it disabled certain macros as well. Any help would be appreciated.

    The groups in question are on rows 5-32, spanned across BCDE if anyway wants to look at the sheet I've attached.
    Attached Files Attached Files
    Last edited by cowboy713; 12-15-2010 at 02:37 PM.

  2. #2
    Registered User
    Join Date
    11-05-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Help locking group boxes so they don't move but buttons inside still work

    Also I recorded a macro to de-select all the choices made for when a new SSQ is beginning through the use of the Hide Participant's Info button on the SSQ Data Entry sheet, but the final radio button is still in an edit mode after it de-selects them all, any idea how to change this or what I'm missing from my code so that it's blank and unselected like the other buttons?

    ^ ignore this issue fixed it already
    Last edited by cowboy713; 12-15-2010 at 02:18 PM. Reason: solved this 2nd issue.

+ 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