Please find the link
http://www.excel-vba.com/vba-prog-1-1-editor.htm
On Fri, Jul 29, 2011 at 5:25 AM, mahamadou lawali wrote:
>
> Thanks a lot for your help, but I am a beginner in VBA.So would you
> guys please break it down for me? I've tried to paste the code and I
> really don't know how
Thanks a lot for your help, but I am a beginner in VBA.So would you
guys please break it down for me? I've tried to paste the code and I
really don't know how to go about it.
Thanks again.
On Jul 25, 11:46 pm, XLS S wrote:
> Hey,
>
> Try this
>
> run this macro and put the password in vba code
Hi
You can use this code on workbook open event.
'User Level 1 is admin usage
'User Level 0 is general usage
if a user logs in using level 1 he can see sheet4 for other users sheet4
will be hidden
Sub test()
If userlevel = 1 Then
ThisWorkbook.Worksheets("Sheet4").Visible = xlVeryHidden
Els
Hey,
Try this
run this macro and put the password in vba code
Sub Macro1()
ActiveWorkbook.Unprotect Password:="xxx"
Sheets("*Sheet1*").Visible = False
ActiveWorkbook.Protect Structure:=True, Password:="xxx"
End Sub
On Tue, Jul 26, 2011 at 8:44 AM, mahamadou lawali wrote:
> I have
I have a workbook with 3 sheets 2 of the sheets are for general use
but one
of the sheets i would like people to access only by a password is this
possible? i can protect the sheet but i would like only certain people
to
view the information? protecting stops people from amending/entering
data.
--
