If you're using Excel 2002 or 2003 you can set Enable Selection to unlocked
cells only through the user interface (Tools, Protection) and it will stick
when the workbook is re-opened. Beyond that it's like you said - you have
to run code.

--
Jim Rech
Excel MVP
"Stuart" wrote in message
...
| If I remember correctly, this setting is not preserved when the workbook
| is re-opened.
| So far I've managed to keep code out of my users' workbooks, so they
| do not see the macro warning message. I'd like to continue that if at all
| possible.
| I could use code in the addin for when the user opens the book via the
| addin's menu, but this wouldn't stop them using Excel's file open method.
| Besides which, much of the user's Excel work is done outside of the addin,
| so I don't want to disable FileOpen for their 'normal' usage.
|
| One thought....If I could 'tag' appropriate workbooks somehow, is there
| a way to to get Excel's FileOpen to check for that tag, and if it exists
| then EnableSelection=xlUnlockedCells. Probably not, but I think that's
| what I need to achieve.
|
| Would be grateful for advice, please.
|
| Regards.
|
|
|
| ---
| Outgoing mail is certified Virus Free.
| Checked by AVG anti-virus system (http://www.grisoft.com).
| Version: 6.0.679 / Virus Database: 441 - Release Date: 07/05/2004
|
|