Showing results for 
Search instead for 
Did you mean: 

Run-time error '1004' Application-Defined or object-defined error

Former Member
0 Kudos

Hello friends,

My requirement is to make the cells under Columns Actual, forecast and target (Dimesnion Category) Locked.

I've used various methods like GetOnlyRange but it didnt work.

Now, i've selected all the cells of the sheet, where user can input and made them unlocked. ( from Right-click>FormatCells>Protection tab-->Locked checkbox unchecked)

Then, go to "review" tab, click "Allow Users to edit Ranges",-> Protect Sheet---> ticked "Unlocked Cells"

Then go to WorkBook Options and set a password for the worksheet.

But on expand, I'm facing Run-time error '1004' Application-Defined or object-defined error.

Please help.

Please help.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Maduhriv,

you have to unlock the worksheet locking before you expand your EVDRE schedule.

After expandation you can lock it again.

You have the posiblity to use these BPC events in you own VBA coding




Hope this helps.

Kind regards


Former Member
0 Kudos


I think that is VBA Runtime error, you can fix these errors by downloading in various sites.

You can try with the above link. I hope this could solve your problem.