Thread
:
Sheet to close
View Single Post
#
1
Posted to microsoft.public.excel.programming
Oldjay
external usenet poster
Posts: 337
Sheet to close
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
Reply With Quote
Oldjay
View Public Profile
Find all posts by Oldjay