Thread
:
how to quit in BeforeClose
View Single Post
#
3
Posted to microsoft.public.excel.programming
Peter[_68_]
external usenet poster
Posts: 2
how to quit in BeforeClose
Hi.
I did find a way:
Sub Workbook_BeforeClose(Cancel As Boolean)
a = MsgBox("Fik du rettet navnet på det nye ark ?", vbYesNo)
If a = vbNo Then Cancel = True
end sub
Thank you
Peter
Reply With Quote
Peter[_68_]
View Public Profile
Find all posts by Peter[_68_]