M
mike_vr
Hi Bob, thanks for getting back to me earlier. This is almost what I was
after, but not quite. If anybody else knows please feel free to throw in an
idea or two?!?
This code still allows the user to open it, after which point the formulae
get reverted to the =#N/A even though the value is still visible. When this
is now re-opened in 2007 the formula is lost (as has been my experience, but
maybe I'm missing something here?!?)
So what I'm really looking for is something like the workbook_open procedure
below but that actually stops them from opening it and giving them a message
to contact me instead before it even opens. Is this possible???
Thanks again for your help,
Mike
after, but not quite. If anybody else knows please feel free to throw in an
idea or two?!?
This code still allows the user to open it, after which point the formulae
get reverted to the =#N/A even though the value is still visible. When this
is now re-opened in 2007 the formula is lost (as has been my experience, but
maybe I'm missing something here?!?)
So what I'm really looking for is something like the workbook_open procedure
below but that actually stops them from opening it and giving them a message
to contact me instead before it even opens. Is this possible???
Thanks again for your help,
Mike