Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2010
    Location
    Cheltenham, Gloucestershire, UK
    Posts
    12
    Thanks
    4
    Thanked 0 Times in 0 Posts
    I don't want to turn off "enable editing" globally - so would like to include a line of code when I open a particular file so that editing is enabled for the duration of the macro (it is saved and closed towards the end).

    A macro which worked well in 2003 falls over now we have 2010 - I get an error message that the file is read only - this leads me to believe it needs to be edit enabled.

    Thanks

    Roberta

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,783
    Thanks
    0
    Thanked 162 Times in 150 Posts
    Hi Roberta,

    It would be helpful if you posted the 2003 macro. Also, have you checked the file's read-only attribute setting via Windows Explorer?
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •