Sheet Activate method in beforesave event
 

Hi

I would like to know why activate method in beforesave event does not
work.
Could you help me?
(If you know, please let me know url of MSDN page explaining this
restriction.)

-----------ThisWorkbook Module--------------

Sub test()
ActiveWorkbook.Save
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Sheets("sheet2").Activate
End Sub

----------------------------------------------------

Case 1 When save by file menu or Ctrl+s
"Sheets("sheet2").Activate" will work.

Case 2 When run test procedure
"Sheets("sheet2").Activate" will not work.


Thanks to all,
bdg