unprotecting excel worksheet

[vb_student]

Hello
I have got this worksheet which does not open normally in windows explorer since it is protected.

i tried to unprotect it from the excel bars but the option was greyed out

i was wondering if i could write some VB code which would unprotect the file and then i could view it normally

[RobDog888]

Are we talking sheet or workbook? If the sheet is only protected then you can open the file with no issues but may
only be able to edit the non-protected sheets.
If its protected at the workbook level then you need a passwrod to unprotect it before opening it.

[RobDog888]

I think your talking Workbook protection so here is a sample.

Option Explicit
'Add a reference to MS Excel xx.0 Object Linrary
Private Sub Command1_Click()
    Dim oApp As Excel.Application
    Dim oWB As Excel.Workbook
    Set oApp = New Excel.Application
    oApp.Visible = True
    Set oWB = oApp.Workbooks.Open("C:\Book1.xls")
    oWB.Unprotect "Password"
    'Do your stuff
    '...
    '...
    oWB.Close True 'Save changes
    Set oWB = Nothing
    oApp.Quit
    Set oApp = Nothing
End Sub

[vb_student]

thanks dude