How to detect if cells with formulas become hard data

[billj]

Hi everyone,

People often select cells in a sheet (or multiple sheets) and do something like copy and paste as values to make all data in that sheet hard data.

Before the cells are made hard data, I want to have a macro to pop up a message to ask the user if he really wants to make them hard data. If he clicks Yes, then go ahead. Otherwise, nothing will happen/

In VBA, I don't know how to track if cells in a worksheet are about to lose their formulas. Can you please help? Thank you.

[ikboy]

Try this:

Please Login or Register  to view this content.

hth
ikboy

[billj]

It did not work as I need. Can someone please help?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[billj]

Thanks, guys.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.