Jonny wrote:

This may be really simple, but is there a way to hide a
sheet in a workbook that is used for bits of information
the user isn't concerned with but the VBA code is.

You can hide a sheet using Format/Sheet/Hide (I guess, I use Spanish
Excel). At least this is in Excel 2002.
To find out the VBA code to do this, just record your steps while doing it.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.