View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gef[_2_] Gef[_2_] is offline
external usenet poster
 
Posts: 1
Default 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