error 800a01a8

[svetlana]

I am running some code in the spreadsheet including user
forms. The only time i get this (800a01a8) error is when i
close the spreadhseet. Does anyone know what it could be?
Thanks!
Svetlana

 

[mhollander38]

Hi Svetlana,
I know this is probably a record wait for a forum reply but I had the exact same problem and ended up here through a search engine and wanted to leave this here so anyone else finding this can solve their problem.

I resolved the issue as I founnd that I had locked my spreadsheet from editing but was running forms to but they were unable to edit the control source as the cells were locked. Solution was to unlock the sheet upon launching the forms using;
ActiveSheet.Unprotect Password:="xxx"

Then to lock the sheet on closing the forms again with;
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
ActiveSheet.Protect Password:="xxx"
End Sub