Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
With the help of Trevor Williams on this board I was able to easily link
hundred of group boxes (with 4 radio buttons in each) to the cell that they were on top of. Here is the code: Sub LinkOptBtns() Dim GrpBox As GroupBox Dim OptBtn As OptionButton For Each OptBtn In ActiveSheet.OptionButtons With OptBtn .LinkedCell = .GroupBox.TopLeftCell.Address End With Next End Sub My problem is that I am starting to lose the links and I am finding myself running the code randomly to re-link them. Can someone help me make the control links permanent? I want to distribute my workbook to many users and will not allow them to access to the VBA. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Option Button - Cell Link Issue | Excel Programming | |||
Second option button disappears when I make another column | Excel Worksheet Functions | |||
Option Button-Format Control-Cell Link... | Excel Programming | |||
Control Cell Link for Option Button based on value in a cell | Excel Programming | |||
Control Cell Link for Option Button based on value in a cell | Excel Programming |