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.
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!
+ 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 167 Times in 154 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]