VB code referencing a hidden worksheet error

Hello all once again,

I continue to cause myself heartache due to lack of knowledge. I have an ongoing workbook that many of you have helped build and a new issue came up today. After hiding a few worksheets that hold reference data only, errors started happening when running user forms that use the data on those sheets. Took me awhile to figure out the "hiding" was the problem.

So, my question is; is there a simple way of changing the syntax so that hidden sheets can still be referenced without the user having access to them? I know this is a quite generic question without sample code/worksheet but my guess is it's not that uncommon of an issue.

Ideas and/or solutions.

Thanks as always.

What exactly are you referencing these hidden sheets to do?
I often have hidden sheets to hold lengthy lists for populating combo boxes and don't recall coming up against issues with them being hidden.

There are issues if you're trying to copy hidden sheets into new workbooks and probably other scenarios (that don't spring to mind at 6am!) but I think we'd need to know a little more about what your forms are trying to do with these hidden sheets in order to provide guidance.

BSB

The user form is to add new data to a worksheet database (this sheet is not hidden). Some of the combo boxes in the user form reference lists that reside on the hidden sheet to make input easier and consistent.

I should probably copy the workbook and attach a cleaned up version to the thread, which would take some time. But I would like to know the "why" just for reference.

It's 12PM here, my mind isn't all that clear either!

Thanks

Difficult to give you "why" without seeing it in context I'm afraid.

BSB