The following code run from a code module will hide the specified sheet.
The user can't even tell it exists. To unhide substitute True in place
of xlVeryHidden. You can then lock the VBPoject to protect anyone from
running the code to unhide.
Transfer of information to the hidden worksheet can still be done by
code; e.g., a "Save" button that the user presses to store the data to
the hidden sheet. The button must invoke a macro that tells it to
transfer the data of course.
Sub HideSheet()
Sheets("Data").Visible = xlVeryHidden 'True to unhide
End Sub
Regards,
Greg
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!