Inactive Form Controls

C

Cam

Hi there,

I am having some issues with form controls in Excel 2004 for Mac. I
opened a document made in Excel 2003 for windows that contains drop
down menus. When I try to use the drop down menus, clicking on the drop
down arrow chooses a cell behind the drop down. How do I go about
activating these drop downs so that I can use them? Thank you for your
help.

-Cam
 
J

JE McGimpsey

Cam said:
Hi there,

I am having some issues with form controls in Excel 2004 for Mac. I
opened a document made in Excel 2003 for windows that contains drop
down menus. When I try to use the drop down menus, clicking on the drop
down arrow chooses a cell behind the drop down. How do I go about
activating these drop downs so that I can use them? Thank you for your
help.
Click to expand...

They are most likely ActiveX controls from the Controls Toolbox rather
than Forms tools.

ActiveX is currently a Windows-only technology, so there's no way to
activate the controls in MacXL. The workaround is to use Forms controls.
 
C

Cam

Ok, thanks for the help JE.
-Cam

JE said:
They are most likely ActiveX controls from the Controls Toolbox rather
than Forms tools.

ActiveX is currently a Windows-only technology, so there's no way to
activate the controls in MacXL. The workaround is to use Forms controls.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Clearing Fields in a Word Form 5
Move Drop Down List to the Top of the Cell 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Documents from shared model are created with design mode on 1
Problems opening and saving Excel 2003 PCfile with Excel2004 for Mac 1
PROBLEM WITH PC CREATED EXCEL SPREADSHEET DROP DOWN MENU 1
Drop Down Menus 2

Top