XLSM dialogue box will not open

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
msgeddes
Posts: 1
Joined: Thu Oct 05, 2017 3:00 am

XLSM dialogue box will not open

Post by msgeddes »

I have an XLSM worksheet that only allows information to be input through a dialogue box. All cells are protected.

When I press the button that shuld open the dialogue box nothing happens

Any suggestions?
Open office 4.1.3
Windows 10
FJCC
Moderator
Posts: 9274
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: XLSM dialogue box will not open

Post by FJCC »

Only very simple Excel macros can be run without modification in OpenOffice. I hear that LibreOffice has a somewhat better ability to run MS Office macros. If your macro is complex, it will have to be rewritten to run on OpenOffice or LibreOffice.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply