View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mohavv mohavv is offline
external usenet poster
 
Posts: 68
Default check if sheet exists

Hi,

I have a lot of workbooks with same structure which I unprotect with a
macro in personal.xls.
However some have one worksheet less, called "FTE"

How can I test in this macro if a worksheet exists and if so unprotect
it and if not goto next line.

Cheers,

Harold