Thread: How to restore a Custom menu if a user presses Cancel after selcting exit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alseikhan[_5_] Alseikhan[_5_] is offline
external usenet poster
  
Posts: 1
Default How to restore a Custom menu if a user presses Cancel after selcting exit

A workbook has the subroutine attached to workbook:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call DeleteMenu
End Sub

to delete custom menu before closing the workbook.
However, if a user changes mind and presses Cancel to keep workbook
open, the custom menu is deleted anyway!

How do you solver this problem?

Thank you.
Alseikhan


--
Alseikhan
------------------------------------------------------------------------
Alseikhan's Profile: http://www.excelforum.com/member.php...o&userid=32364
View this thread: http://www.excelforum.com/showthread...hreadid=529491

Reply With QuoteReply With Quote