Store lookup table in vbe module

[Rowland Hamilton]

How can I store a lookup table in vbe module instead of a worksheet (hidden or visible). Is this possible?
Or, could I pull the contents out of an existing lookup table, delete the workhseet, and have vba add a new worksheet and recreate the table? - Thank you, Rowland

 

[GlennUK]

Please provide more information about what you are trying to do.

And explain why you can't simply copy and paste the table,if you want it transferred from an existing place to a new worksheet?

 

[Rowland Hamilton]

Glenn: Appreciate your responds.

I don't want any lookup tables in the workbook so the end users can't see it or undhide it. Trying to not affect the original workbook beyond adding th enew sheets.

Thank you - Rowland

Note:
I hear there is a super hidden where the sheets don't come up when viewing hidden sheets list but if you don't remember the sheet name you can't unhide it ever, so I don't want to use that.

 

[GlennUK]

I find this contradictory:

don't want any lookup tables in the workbook so the end users can't see it or undhide it. Trying to not affect the original workbook beyond adding th enew sheets.

Either you don't want any lookup tables in the workbook, or you add new sheets with the tables. You seem to say you want both.

You can set a sheet visibility to xlVeryHidden, and the user won't be able to unhide it, as long as you protect the project from viewing, as such a sheet can be made visible from the VBE very easily.

 

[Rowland Hamilton]

Glenn/Folks:
"Have your cake and eat it, too" is exactly what I want. Use a lookup table but not have it exist in a worksheet.

I seem to remember a presentation where the programmer stored his lookup table as an index sheet in the VBE? Maybe I misunderstood. I'm still not sure if its possible. Let me know.

Thank you, Rowland