Transfer of files from one pc to another & now no commands work

[ipbr21054]

I have copied a folder with excel files & moved it to another pc using dropbox.
I open up my file & see all my images & worksheets, so far all look good.

I then click on a command button which should take me to the top but nothing happens.
I then click on another that should open a userform but yet again nothing happens.

I right click on the tab & select view code of which i am able to do so but sometimes i see ERROR IN DLL

It seems that all the macros are disabled / non working

 

[ipbr21054]

Just an update.
I had copied say 20 sheets & ive just check through half of them & all the forms open etc etc.
The post i mention above is for the sheet thats the most important of then all.
Just check after checking the others but confirm not working etc

 

[ranman256]

are macros enabled on that pc?
does the code use preferred UNC paths (\\server\folder\) or frowned upon assigned Drive letters? (F:\folder\)
is the code in the workbook or Personal workbook?

 

[ipbr21054]

Please see my second post with regards the others all working

 

[ipbr21054]

Ive just downloaded the file again from Dropbox.
I double click on the file in question & the sheet opens, i then see a message to say Could not load an object because it is not available on this machine.
It doesnt say or point to what it is though.

I click the ok button.

I click a command button to take me to the top & this time it worked.
I then click a command button to open a userform but then see this pop up

 

[NoSparks]

With my Excel 2010 on Windows 10 seems to me that I get that with all the files you have shared.
There always seems to be something marked as missing under Tools -> References
If I remember correctly just uncheck and it then works

 

[ipbr21054]

I dont see where the Tool References is located please advise

 

[NoSparks]

I googled "vba tools references" and got this

 

[ipbr21054]

I found it as email came through.

Do i remove tick on both missing items ?

 

[ipbr21054]

So after 3 tries i was then able to remove the tick from the 2 MISSING OPTIONS.
Before kept getting an error message but now im past that.