Test that a workbook is open
Hi,
I have a macro that I want to start with a paste command
(data copied from another system) but only if the
following conditions are met:
1 There is a worksheet open
2 It is empty
3 The first two columns have been formatted as text.
I can do (2), and can set the columns to text before the
paste - so can do (3).
Can anyone help me with a test to ensure there is a
worksheet open (a user might press the icon I set up when
there is no workbook open)
Thanks,
Gef
|