andrewerman
New Member
- Joined
- Jul 25, 2014
- Messages
- 1
I'm facing an interesting problem...
I have a password protected spreadsheet with multiple tabs. On one of the tabs, there are some radio buttons. I want the radio buttons to have macros assigned to them.
When I assign the macro in visual basic modules, the macro works fine but the radio button display gets messed up. The text goes away and the box around the radio button gets thicker.
When I put the macro in the area of visual basic associated with that particular sheet, then the visuals are fine, but I can't have the macro selecting/activating other tabs or specific cells from other sheets. I'm pretty sure this isn't 'fixable' because it's running the macro privately in the particular sheet, but maybe others know better.
Does anyone have any ideas how to fix either or both issues?
I have a password protected spreadsheet with multiple tabs. On one of the tabs, there are some radio buttons. I want the radio buttons to have macros assigned to them.
When I assign the macro in visual basic modules, the macro works fine but the radio button display gets messed up. The text goes away and the box around the radio button gets thicker.
When I put the macro in the area of visual basic associated with that particular sheet, then the visuals are fine, but I can't have the macro selecting/activating other tabs or specific cells from other sheets. I'm pretty sure this isn't 'fixable' because it's running the macro privately in the particular sheet, but maybe others know better.
Does anyone have any ideas how to fix either or both issues?
