LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 413
Default .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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EnableSelection Protecting sheet question Damian Excel Discussion (Misc queries) 3 September 25th 09 08:07 PM
EnableSelection = xlUnlockedCells Stuart[_5_] Excel Programming 1 January 28th 05 12:39 AM


All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"