Ask Your Question

Form Controls Greyed out [closed]

asked 2014-07-30 15:16:55 +0100

Bryan Neff gravatar image

I had a complicated sheet I built in Excel, but some of our people use LibreOffice Calc instead. So I opened the document in Libre and reinserted my VBA, but I had three buttons that I needed to work.

Unfortunately, I can't seem to assign a macro to the buttons. When I went into form controls, all I have available are 'Select, Design Mode, Form, Form Design, More Controls, Wizard On/Off'. All other buttons are greyed out and can't be selected, and I'm not sure why.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-01 16:40:54.513509

1 Answer

Sort by » oldest newest most voted

answered 2014-07-30 18:12:46 +0100

Lupp gravatar image

updated 2017-08-17 20:41:45 +0100

Did you click 'Design Mode On' and then 'Control''? Having selected a control this should open the property editor for the control. (You surely know there are 2 toolbars concerned with Forms / Controls.)

Editing 2017-08-16 with repect to below comment
'View' > 'Toolbars' : Select 'Form Design' and 'Form Controls'.,

edit flag offensive delete link more


Where are either of those things? I don't see anything that says 'Design Mode On' or 'Controls'. You should really include screenshots with UI based answers.

Umaroth gravatar imageUmaroth ( 2017-08-17 20:02:30 +0100 )edit

The thread is 2y+ old. . Quoting @Umaroth: "You should really include screenshots..."
Fell free to do so if you once write an answer. I prefer a few clear words where applicable.

Lupp gravatar imageLupp ( 2017-08-17 20:40:57 +0100 )edit

Question Tools

1 follower


Asked: 2014-07-30 15:16:55 +0100

Seen: 5,411 times

Last updated: Aug 17 '17