View Control of Form Controls
In my Excel workbook, sheet1, I have added several option (radio) buttons
from the Forms Toolbar along with some frames and checkboxes. In cell B10,
and C10 I have two radio buttons, one is €śPre Sales€ť and the second is €śPost
Sales€ť
If I select €śPre Sales€ť I will hide rows 50-100 which is the Post Sales
information. If I select €śPost Sales€ť I will hide the €śPre Sales€ť rows
15-49. I can do this hide show, no problem by creating views, however, any
form objects, frames, checkboxes or radio buttons in these sections do not
hide, they always show.
How can I control the form objects using views, or hide/show?
|