I have set up a spreadsheet where I can run 2 macros to use 2 other
worksheets to gain the price of items according to different types of cost.

In simple terms, when I open the original sheet, it works fine with the
macros I have written. When I then 'save as' and re-open, the macros do not
work.

Please can someone help me, in simple language, what I can do to rectify this.

Thanks

Hi,

Please show us your code.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Claireybelle90" wrote:

I have set up a spreadsheet where I can run 2 macros to use 2 other
worksheets to gain the price of items according to different types of cost.

In simple terms, when I open the original sheet, it works fine with the
macros I have written. When I then 'save as' and re-open, the macros do not
work.

Please can someone help me, in simple language, what I can do to rectify this.

Thanks