activate formula bar only after save or don't save is selected but not cancel

[LFKim2018]

in the before close event how do I write the vba code for this scenario:
if the button selected is either SAVE or DON'T SAVE then do activate formula bar (which was deactivated in the workbook open event) otherwise do nothing

if button <> cancel then
activate uniform bar
endif

thank you

 

[Jaafar Tribak]

You could replace the beforeclose prompt with a userform with 3 buttons and respond to the user's choice accordingly.