Change data in temporary created file to value

Hi Folks,

I have a macro that, using formula generated data from a 'Master' file, generates a 'Temporary' file.

What I'd like to do is ensure that the data in the temporary file is changed from the formula generated to values. (I can't change the formula or values in the original file).

This is the code I have that generates the temporary file. Can anyone tell me what code I need to insert where to achieve this please.

Many thanks.

Please Login or Register  to view this content.

Hi there,

This is just a knee-jerk (and untested) response, but try adding the highlighted code to your own version:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

HI Greg,

That's brilliant, it works. (Rep Added - for this alone!)

However, I've also discovered I've got two buttons, with macro's assigned, that also cross reference the original file

Rectangle:Rounded Corners 1
Rectangle:Rounded Corners 2

I don't need them in the copied file. Are you able to come up with a code to delete them please.

Many thanks

Terry

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

To remove the buttons try adding the highlighted code as shown below:

Please Login or Register  to view this content.

Hope this helps - as before, please let me know how you get on.

Best regards,

Greg M