If wsShtToSave.Name = "Master" Then


Gord Dibben MS Excel MVP


On Sun, 13 Dec 2009 08:30:01 -0800, oldjay
wrote:

Why won't this work?

oldjayo

Sub test()

Dim wsShtToSave As Worksheet
Set wsShtToSave = ActiveSheet
If wsShtToSave= "Master" Then
ActiveWorkbook.Save
ActiveWorkbook.Close
End If
End Sub