How do I save Open Office Spreadsheets?

Posted on 2009-12-20
Last Modified: 2012-06-27
I have several spreadsheets that were created in MS Excel 2003.   I had them marked as read only.   When I used MS Excel to open these files, I was able to make changes to the cells then print the sheet.   I did not want to save the changes.   Now when I open these files with Open Office, I cannot make changes as the file is read only.   How can I make these changes without allowing the changes to be saved, but just print the changed sheet?   I do not want to use MS Excel any more.
Question by:DoctorK12008

    Expert Comment

    It is important
    LVL 3

    Expert Comment

    Save As instead of saving or overwriting the file.
    LVL 5

    Expert Comment

    i would convert to template and use Workbook_BeforeSave event  to prevent it being saved if you really dont want it saved  though it wont matter as they cant edit the template as it will be save only

    Author Comment

    I do not know what is meant by "use Workbook_BeforeSave event".   Please explain.   Thank you.  
    LVL 5

    Accepted Solution

    I can only do this in excel but once you save the file as a template with the code then you can use it in open office

    I dont think you will need to bother with read only

    in Excel
    Hit alt F11
    First add protection to the project
    Right click on the vba project for your workbook in the left pane
    Properties | Protection | Lock for viewing
    put in a password if you want & write it down
    (I havent locked the one I am putting up)

    Next add the code
    Expand the project by clicking on the "+" just to the left of the project
    Expand Microsoft excel objects
    Double click "ThisWorkbook" module
    In the left dropdown of the right pane
    choose "Workbook"
    Replace everything in the right pane with the code below

    Edit the MyDevelopmentFolder  (path) to point to the folder where you are going to store the workbook when you are going to edit & save it yourself.

    Save the file as a template
    Due the the upload system on this site not accepting xlt files (2003)
    I had to upload my example as an xls but once yuo save it to your hdd then just edit the file name from "Cannot Be Saved.xls" to "Cannot Be Saved.xlt"
    ie. rename to change to a template
    excel 2007 has different extensions use xltm
    sing out if you get stuck

    Option Explicit
    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Const MyDevelopmentFolder = "C:\# Expert2Expert Projects"
    If ThisWorkbook.Path <> MyDevelopmentFolder Then Cancel = True
    End Sub

    Open in new window

    LVL 5

    Expert Comment

    Thanks & cheers

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now