Need help for range to automatically copy and paste as values before closing workbook

I have range of cells that are linked that I want to be converted to values when I close out. Is there any way possible to do this similar to like how the 'Do you want to save changes window' pops up when exiting?

Thanks

Hi Ricky,

In the workbook's BeforeClose event, you should be able to do something along the lines of:

Please Login or Register  to view this content.

This will replace the formulas in the range specified to values. Change your sheet name and range accordingly.