Jim -
By any chance did you link the controls to a locked cell and then turn
protection on? <
I am using a definition table on an Excel 4 macro sheet to specify a dialog
box. As far as I know, there is no way to link this kind of dialog box item
(option button, option button group, or group box) to a cell. I posted a
simple example, the three-option dialog box macro sheet; by default, all
cells are locked; the macro sheet is not protected.
Strictly speaking, I am not using "controls." I think Form controls began in
Excel 5 and ActiveX controls in Excel 97. And, strictly speaking, I am not
creating a "user form." But, based on my limited testing, the Excel 4
feature of specifying a dialog box (using a definition table on an Excel 4
macro sheet) still seems to be supported on all Windows and Mac versions of
Excel, except that the option buttons do not work properly on Mac Excel
2008.
- Mike
"Jim Gordon MVP" wrote in message
...
Mike Middleton wrote:
Mac OS X 10.5.6
Mac Excel 2008 12.1.5
(Posted on microsoft.public.mac.office.excel and
microsoft.public.excel.programming)
I am using Excel 4 XLM macro programming language to develop an add-in
for Mac Excel 2008. The add-in design has several custom dialog boxes
(specified by dialog box definition tables). Most code and dialog box
functions work fine.
The immediate problem is an option button group. The group box and option
buttons display properly, but the option buttons do not respond to mouse
clicks in Mac Excel 2008. The option box specified in the initial/result
column of the definition table continues to be selected, and it is
impossible to select any one of the other option buttons in the group.
As far as I can tell, the dialog box, group box, option button group, and
option buttons have been specified correctly. The option buttons do
respond to mouse clicks in Windows Excel 97-2007, Mac Excel X, and Mac
Excel 2004. But the same XLM dialog box does not respond to mouse clicks
in Mac Excel 2008.
I would like to know if this behavior is a bug or if there is something I
can do to get an option button group to work properly in Mac Excel 2008.
I have posted two examples of XLM code and corresponding add-ins at
http://www.mikemiddleton.com/Excel4X...ionButtons.htm
- Mike
Email
By any chance did you link the controls to a locked cell and then turn
protection on?
-Jim
--
Jim Gordon
Mac MVP
http://mvp.support.microsoft.com/