code not working when moving command button to different sheet

[Chris1976]

Hi There , I have the below code which works perfectly fine. The command button was first placed on the "Summary_Maint_List" sheet. I then created a User Landing Page (UI) called "UI_Annual_Planner" and copied the command button there so that the code can be activated from the UI page.

I also included a small code at the bottom (red) that un hides the Maint_List_Sheet and it opens that sheet.

The problem is, now that i have copied the command button to the UI sheet the code no longer works, when I copy it back to the Summary_Maint_List it works fine

does anyone know why that happens

Please Login or Register  to view this content.

[sintek]

Chris chris chris...

By now you should know a sample file speaks a thousand words...

Anyway...when you copy over the code is not copied over as well...
Apply code to that CommandButton

[Chris1976]

lol,hi Sintek, I know I'm a sinner sorry I forget these things sometimes

I found the problem tough , because the sheet itself has a very hidden code on the sheet itself the code did not run

so i took

Please Login or Register  to view this content.

and placed that at the begging of the code making the sheet visible first before running the rest of the code