I should have stated "when the user closes the Excel application and selects 'No' or 'Yes'. The spreadsheet will remain open until closed by the user. I have checked all the servers and the workstations and macro security is set to "Medium" but it never asks to enable the macros.
Thanks,
Fred