Ask Your Question
0

Form Controls Greyed out [closed]

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

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.

Version: 4.1.0.4

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
1

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

Lupp gravatar image

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

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

Comments

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 +0200 )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 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 4,295 times

Last updated: Aug 17 '17