I have several sheets that I'd like to hide from view to prevent users from doing things they should not do. The macros do various sorts and export updates to other workbooks. Is it not possible to hide sheets and make calls to them? I get a run-time error '1004' select method of worksheet class failed.
If I can't hide these sheets, can I prevent users from selecting these sheets for viewing? Any ideas?

JS