![]() ![]() Any ideas? I'm running Xubuntu 12.04 64-bit. So, what other options are there left for me? I have been searching around Google/Bing but haven't found a solution yet. ![]() ![]() I do not have Windows, I do not own MS Office and have no means or desire to buy either one. In this example, we will also disable the copy and paste in excel without macros by protecting the worksheet with the option Protect Sheet.But unlike the previous example, this time we will enable the selection of cells in our worksheet. I installed Calligra and tried opening it with Sheets, but Calligra just freezes and I have to force quit out of it. Criteria 2: Selection of Excel Cells is Enabled but Copy and Paste are Disabled without Macros. 1) Before enabling the macros try adding a new blank sheet, and then save the spreadsheet, reload, and sometimes it corrects itself. Some of the macros seemed to work in Gnumeric but most of them didn't. xls document to a LibreOffice document and LibreOffice still won't run the macros. How to enable Personal Macro Workbook in Excel. For this, just open the worksheet in which you want to run the macro, and do the following. I even went to Tools -> Options -> Security -> Macro Security -> and set it to Low. Macros stored in your personal workbook can be used in any Excel file. I tried opening the document in LibreOffice and the macros won't work even though I went to Tools -> Options -> Load/Save -> VBA Properties -> and made sure Load Basic Code and Executable Code were both checked. I'm having a problem finding a program what will allow me to open the document and the macros work. I have a spreadsheet written in MS Excel, an. ![]()
0 Comments
Leave a Reply. |