Thread: Excel 2010 - "enable editing"
2010-12-01, 16:39 #1
- Join Date
- Sep 2010
- Cheltenham, Gloucestershire, UK
- 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.
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!
+ 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!
2010-12-04, 20:46 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 188 Times in 172 Posts
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,
[MS MVP - Word]