Code not working in Office 2010 and Office 2016

[amitmodi_mrt]

Hi All, I have below code which i created in Excel 2013, it is working fine in my computer, but it is not working in any other computer who has MS office 2010 or Office 2016, they are getting "Compile Error in Module 1". I not able to figure out where is the issue. when tring to do Debug it showing me error on.. "Cancel = True". Below is the complete code.

Any help in this will be appreciated. Thanks in advance.

Please Login or Register  to view this content.

[JBeaucaire]

Cancel= True is typically found in sheet module event macros, not in regular code modules. Perhaps if you declared it? Shot in the dark:

Please Login or Register  to view this content.

[AB33]

If you have declared all your varaibles, it would help you to spot an obvious error.
I have 2010. I run the code and did not get an error.

Please Login or Register  to view this content.

If the code errors, It might be on this line( though it does not error)

mymenubar.Controls("Edit").Controls("Delete sheet").Visible = False
The menus might have been changed.

[amitmodi_mrt]

Hey thank a lot.. it fixed it by adding the Dim as u suggested...