Execute code on exit

[Flipflash]

In a shared workbook, I have the following macro that runs perfectly, linked to a button on a ribbon. However, if the same code is inserted into the VBA Workbook BeforeClose window, I get the following message, "The command could not be completed by using the range specified. Select a single cell within the range and try the command again." The macro stops on the 'Selection.AutoFilter' function.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Flipflash]

Hello John and thank you for your input. Unfortunately, this created a different issue. I now get a message because the worksheet is protected. If I leave it unprotected, the pasted data is of the underlying formulas, not the resultant data. The script stops at the first ActiveSheet.Paste line.

[JOHN H. DAVIS]

OK. I just ran a quick test on some dummy data I made up. Thought what I did might be the issue. Didn't know your sheet was protected.

[Flipflash]

I apologize for leaving that bit of out my initial post. Hopefully, there won't be any other surprises.

[Flipflash]

Still no resolution. Looks like I may have to live with the button function instead of having the macro execute automatically on exiting the program.