I have a file with numerous vba functions. I recently copied the file to
model a different scenario but when I open the copied file I am not being
asked to "enable Macros", the file is just opening up straight away.

My macro security is still set to Medium but now when the file opens up all
my macros appear to be disabled and I get #Name? outputs in the cells
utilizing the vba functions.

Any idea what I've done AND how I fix it?