View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tod Tod is offline
external usenet poster
 
Posts: 13
Default Test if Auto Outline is True

My code uses Auto Outline like this:

ActiveSheet.Range("A2:T50").AutoOutline

However, if the sheet is already outlined it displays a
prompt. I'd rather is skip the statement if the sheet is
already outlined. Is there a statement I can use to first
test if the sheet is already outlined?

tod