Identifying sheet type

[THEGOB]

I am using the sheet.type to identify the type of sheet in the workbook.

It appears to be returning the following values:

worksheet = -4167
Int Macro Sheet = 4
MS Excel 5.0 Dialog = Blank

Chart = 3
MS Excel 4.0 Macro =3

Obviously the last two require an additional step in the code to determine whether a chart sheet or not.

Does anyone have an alternative method of solving this issue?

 

[Derek Brown]

Have a look at the following for ideas:
http://excel.tips.net/T002538_Detecting_Types_of_Sheets_in_VBA.html
You could perhaps convert it to a function to return the result.