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