View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson[_2_] Greg Wilson[_2_] is offline
external usenet poster
 
Posts: 1
Default Protecting a worksheet from veiwing but not from importing in data

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!