Reply to thread

Message: [QUOTE="brookly, post: 6112969"] Yeah! So close!! This works great when I close file2 with the small "x". The problem with that is that I have a macros running to eliminate toolbars when the userform shows (just for presentation sake). When the user clicks the command button in file1userform that sends them to file2, I reset the toolbars. I have added a command button directly onto file2 spreadsheet that I want to "clear all" toolbars and close file2 without saving changes. When I use that command button to close file2 instead of the "x", my userform does not show again in file1 which is still open. Here is the code on the command button in file2. Private Sub CommandButton1_Click() 'ClearAll runs a macros to eliminate toolbars and unsightly excel background ClearAll ProdWorkbook.Close savechanges:=False End Sub What am I missing? P.S. You're saving my life! [/QUOTE]