Prev: Simple shared code library, also how to find spreadsheets with macros in them
Next: Compare worksheets
From: Bony Pony on 11 Mar 2010 11:30
Hi all,
In VBA, is it possible to determine the address at which a sheet is locked?

I found a property activewindow.splithorizontal and splitvertical but they
give me double length integers. Anyone know how toconvert this int an
address?

Kind regards,
Bony

--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."
From: Mike H on 11 Mar 2010 11:57
Hi,

You have an answer in your post in general questions
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Bony Pony" wrote:

> Hi all,
> In VBA, is it possible to determine the address at which a sheet is locked?
>
> I found a property activewindow.splithorizontal and splitvertical but they
> give me double length integers. Anyone know how toconvert this int an
> address?
>
> Kind regards,
> Bony
>
> --
> "There are 10 types of people in this world. Those who understand Binary
> and those who don''t ..."
 | 
Pages: 1
Prev: Simple shared code library, also how to find spreadsheets with macros in them
Next: Compare worksheets