software

hi,could anyone tell me how to protect hide worksheet so that people couldn't
unhide the worksheet.

thanks in advance...Lawrence

Hi

1. Activate VBA editor (Alt F11)
2. In VBA-Project window (the leftmost upper one), select the worksheet you
want to hide.
3. In Properties window (below VBA-Project vindow - when you don't have such
one there, then activate it from menu), set the Visible property for
worksheet to xlSheetVeryHidden.
4. In VBA-Project window, right-click on your project (with your workbook's
name in brackets), and select VBA-Project Properties from drop-down menu.
Activate Protection tab, and enter password for VBA-project (otherwise any
user can change sheet's Visible property back to xlSheetVisible). OK.
5. Close VBA editor. There you are!--
Arvi Laanemets
( My real mail address: arvillt;atgt;tarkon.ee )
quot;Lawrencequot; gt; wrote in message
...
gt; hi,
gt;
gt;
gt; could anyone tell me how to protect hide worksheet so that people couldn't
gt; unhide the worksheet.
gt;
gt; thanks in advance...
gt;
gt;
gt; Lawrence
sorry...

can i send to your email address, coz i still can't do it..
quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; 1. Activate VBA editor (Alt F11)
gt; 2. In VBA-Project window (the leftmost upper one), select the worksheet you
gt; want to hide.
gt; 3. In Properties window (below VBA-Project vindow - when you don't have such
gt; one there, then activate it from menu), set the Visible property for
gt; worksheet to xlSheetVeryHidden.
gt; 4. In VBA-Project window, right-click on your project (with your workbook's
gt; name in brackets), and select VBA-Project Properties from drop-down menu.
gt; Activate Protection tab, and enter password for VBA-project (otherwise any
gt; user can change sheet's Visible property back to xlSheetVisible). OK.
gt; 5. Close VBA editor. There you are!
gt;
gt;
gt; --
gt; Arvi Laanemets
gt; ( My real mail address: arvillt;atgt;tarkon.ee )
gt;
gt;
gt;
gt; quot;Lawrencequot; gt; wrote in message
gt; ...
gt; gt; hi,
gt; gt;
gt; gt;
gt; gt; could anyone tell me how to protect hide worksheet so that people couldn't
gt; gt; unhide the worksheet.
gt; gt;
gt; gt; thanks in advance...
gt; gt;
gt; gt;
gt; gt; Lawrence
gt;
gt;
gt;

What is ur real email address, i can't assess into arvillt;atgt;tarkon.eelawrence

quot;Arvi Laanemetsquot; wrote:

gt; Hi
gt;
gt; 1. Activate VBA editor (Alt F11)
gt; 2. In VBA-Project window (the leftmost upper one), select the worksheet you
gt; want to hide.
gt; 3. In Properties window (below VBA-Project vindow - when you don't have such
gt; one there, then activate it from menu), set the Visible property for
gt; worksheet to xlSheetVeryHidden.
gt; 4. In VBA-Project window, right-click on your project (with your workbook's
gt; name in brackets), and select VBA-Project Properties from drop-down menu.
gt; Activate Protection tab, and enter password for VBA-project (otherwise any
gt; user can change sheet's Visible property back to xlSheetVisible). OK.
gt; 5. Close VBA editor. There you are!
gt;
gt;
gt; --
gt; Arvi Laanemets
gt; ( My real mail address: arvillt;atgt;tarkon.ee )
gt;
gt;
gt;
gt; quot;Lawrencequot; gt; wrote in message
gt; ...
gt; gt; hi,
gt; gt;
gt; gt;
gt; gt; could anyone tell me how to protect hide worksheet so that people couldn't
gt; gt; unhide the worksheet.
gt; gt;
gt; gt; thanks in advance...
gt; gt;
gt; gt;
gt; gt; Lawrence
gt;
gt;
gt;

Hiquot;Lawrencequot; gt; wrote in message
...
gt; What is ur real email address, i can't assess into arvillt;atgt;tarkon.eeYou have to edit it slightly (replace quot;lt;atgt;quot; with one character proper for
mail address. I'll never use my full mail address anymore, where search
robots can find it - various NG's are popular source for spammers).
Btw. you better use the address arvi.laanemetslt;atgt;tarkon.ee instead (again,
replace lt;atgt; there) - the old one works as far I know, but who knows:-)

Btw. when you weren't able to follow instructions, and want to send the file
so I hide the sheet, then I'm afraid you aren't able to make the sheet
visible later too. Maybe you better try to hide it yourself yet and make
yourself to understand the process - where did you get stucked at all?
--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )