Thread: Corruption?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Preston Mike Preston is offline
external usenet poster
 
Posts: 8
Default Corruption?

Can I assume that if I abend when running the following public
function that I have some form of corruption in my workbook? If so,
any suggestions as to the best way to create a workbook without
corruption?

Public Function ShowItAll() as Boolean

For i = 1 To Worksheets.Count
Sheets(i).Visible = True
Next i
ShowItAll = True
End Function

The line "Sheets(i).Visible = True" consistently gives me an error
that Excel needs to shut down after the 9th and before the 10th
worksheet in the workbook is set to visible.

Thanks

mike