Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.EnableSelection = xlUnlockedCells
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EnableSelection Protecting sheet question | Excel Discussion (Misc queries) | |||
EnableSelection = xlUnlockedCells | Excel Programming |