Code will only execute from one sheet

Hello, I have read this user form code eight thousand times and cannot find what I am missing but this code currently will only run if the active sheet is "DATABASE". If I attempt to run it with another sheet active I get Run Time Error 1004: Application-defined or object-defined error.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

It's because you're referencing Worksheets("DATABASE"). Try using ActiveSheet, although this could produce errors if you try and run the code on a sheet which isn't set out exactly the same as "DATABASE".

Dion

Please Login or Register  to view this content.

ps. You'll need to change the reference in Userform_Activate also.

Paul, thank you so much. I understand now and will try to fix it and may be back if I cannot. :P

mojo249, the end code must be able to run from any activesheet so unfortunately that solution will not work for me. Thank you!

I am going to ask for advice before I start this actually. Currently I have one module that creates reports based on a selection from the database sheet. I am working on a userform that allows other users to select from a listbox which reports they would like to generate. My plan was to have the userform select the desired cells in the database and then run the report creation macro. I do not want the users to have direct access to the database worksheet though so I wanted it to remain hidden throughout. If I cannot select the cells on an inactive worksheet (and I don't believe it is possible to activate a hidden worksheet) what is the best way to accomplish this?

Is this description clear enough?