Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
With the help of the community here I was able to find code that helped me
link hundreds of radio buttons on multiple worksheets to cells with a macro. I am running into a strange situation where sometimes the links are broken and I have to run the macro again (why is that happening?). To ease my mind I would like to change the code to the workbook activate event and have it run each time I open the workbook. I would like to change the code to run on multiple worksheets (now it just has active worksheet). Can someone please help me with my code below, I am a beginner with VBA: 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 Also, if someone knows a way to add a message box that automatically opens to says something like "workbook loading..." and then close when the macro completes that would be great!!! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Activate Workbook | Excel Programming | |||
Workbook.Activate / Window.Activate problem | Excel Programming | |||
Workbook.activate | Excel Discussion (Misc queries) | |||
Activate Other Workbook | Excel Programming | |||
Activate Workbook | Excel Programming |