Hiding Group Box (Form Control)

[Foster]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a spreadsheet with 3 columns of about 40 radio buttons. Each row has a Group Box to separate the selections. Although I can't resize the boxes to fit exactly within the rows, they work.
Anyway, how do I hide these boxes from sight. I already have them selected to not print, but I want to keep this form digital without showing these boxes.

Thoughts?

Thanks . . .

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a spreadsheet with 3 columns of about 40 radio buttons. Each row has a
Group Box to separate the selections. Although I can't resize the boxes to
fit exactly within the rows, they work.
Anyway, how do I hide these boxes from sight. I already have them selected to
not print, but I want to keep this form digital without showing these boxes.

Unfortunately, there's no way to do it using the XL interface. However,
you can use this applescript:

tell application "Microsoft Excel"
set my_sheet to active sheet
try
set my_groupboxes to every groupbox of my_sheet
repeat with my_box in my_groupboxes
set visible of my_box to false
end repeat
end try
end tell


Change "false" to "true" to make them visible again.

 

[Foster]

Thanks J.E. You rock!!!!