VBA 1004 Error when editing a cell

[Dragonmann]

Okay,

I think this should be an easy one, but my brain is fried already.

I have a Macro that runs when the active sheet changes. I use it to populate pull downs on the sheet based on prior inputs.

However, if the active sheet changes while a cell is being edited, excel throws a 1004 error.

Users shouldn't be building formulas, and ABSOLUTELY have no need to build formulas that reference across pages.

All I need to do is accept the current state of the formula bar before activating the new sheet.

 

[kpark91]

I'm not too sure but you might want to look for worksheets being locked while the code is being run.

I dunno but something like
Worksheets("Sheet1").Locked = True
at the start of the code

Worksheets("Sheet1").Locked = False
MsgBox "Successfully executed the macro"
at the end of the code

 

[dave3009]

I think that might wanna be

Sheets("MySheet").Unprotect "Password"

'...Code

Sheets("MySheet").Protect "Password"

 

[Dragonmann]

Thank you for the suggestions.

Everything is working now