Run-time error '1004' Method 'Save' of object '_Workbook' failed

G

Guest

Hi,

I have a code as shown below

Private Sub Workbook_Open()
With ThisWorkbook
.Worksheets("HS OVERVIEW").Activate
.Unprotect ("pas")
.Worksheets("LookUpValues").Visible = xlSheetVeryHidden
.Protect "pas", Structure:=True, Windows:=False
.Save
End With
End Sub

When I open my appliacation in excel it throws me error

Run-time error '1004'
Method 'Save' of object '_Workbook' failed

Can't figure out why this is happening.
Help is appreciated.

Thanks,
Neelam
 
F

Frank Kabel

Hi
tested your code and it works without a problem for me. Some ideas:
- is your file saved as read only
- shared workbook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time Error '1004' 1
Save failing 2
Run-time error '1004' with ActiveWorkbook.Save 2
Run-time error: '1004' 4
Method 'CheckIn' of object '_workbook' failed 1
Run time error 2
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed 15
Run-time-error 1004 "ListIndex method of listbox class failed" 1

Top