Problem with compatibility on other devices??

Hello,

I have a weird problem with my VBA program on excel... My program runs fine on my computer, but i decided to put it on a other device to test it.
It appears that the command buttons won't react when i click on them... I can launch the userforms from the F5 function but not from my original command buttons.
Then i decided to create a new sheet, and added a command button with the command to open the userform and it works ! This could've been a solution but the thing is VBA doesn't recognize the ranges when i call for a sheet. For example when i call the value of A1 cell in my first sheet (Sheets(1).range("A1").value) it pops up an error. But when i call for a value in A1 cell of one of the newly created sheets it does work! i don't understand why it does that.

Thanks for the help!

Ok so my code on my first worksheet:

Please Login or Register  to view this content.

Simple as that. The userform won't show up when i click on the command button. Now if i launch the userform from F5:

Please Login or Register  to view this content.

The error goes on the line with the sheet selection
This code works fine on the computer where it was created. But not on another device.

Now weird thing is, if i add a new sheet and create a new code on the new sheet:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Same code, it works fine...

Ok thanks that does work for my button problem, but still the sheets selection won't work at all...

Yes it does! i didn't even see, but it actually works :D
Thank you very much!