Prev: Answer Message Box - Other than Y/N?
Next: Using Color as Criteria in Countif Function
From: Project Mangler on 25 May 2010 15:26
Hi AB,

I've seen this before - people suggesting that the code needs to
unprotect/write/re-protect.

The userinterfaceonly parameter allows code to modify the sheet, but not the
user.

Am I missing something?

"AB" <austris.bahanovskis(a)gmail.com> wrote in message
news:d0c2a25f-7918-4f69-8201-3a546d9ad018(a)v18g2000vbc.googlegroups.com...
> You could:
> 1. protect (as per earlier post by Prject Mangler) your wb or ws
> (depending on what you want)
> 2. write your 'Run' code so that it:
> 2.1. unprotects the wb/ws
> 2.2. does the thing you want
> 2.3. re-protects teh wb/ws again.
> Additional (not fool-proof) feature you can implement is you can
> change your fileaccess to read-only on the fly, if you want to.
>
> This way your file would be 'open' for user to mess about only during
> the macro run time (during which they can't mess around with it) or
> when it's read-only (and then you almost don't care).


First  |  Prev  | 
Pages: 1 2
Prev: Answer Message Box - Other than Y/N?
Next: Using Color as Criteria in Countif Function