on 03-25-2010 4:25 AM
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.
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
BEFORE_EXPAND
and
AFTER_EXPAND
Hope this helps.
Kind regards
Patrick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
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.
Regards,
B.S.RAGHU
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.