Recent content by GioP

Thanks for clarification So no 3D effect and only shade from side. I agree no point to shade column to imitate background effect. P.S. Let’s see if my next thread will have a solution. :) Thanks again and regards

Good people over there. :) Does anyone know if it is possible in full screen mode to align visible columns in the middle of the screen? (Rest of the columns are hidden). In other words like it works in “Word”, in full screen mode under “view options” if you select “Show one page” the page is...

DONE Sorry being late guys to reply, but I’m sure it is never late to admit that the code is perfect. King is down - Check Mate. SIR your code works perfectly well so for me your status from Sir has changed to IT GOD. Ok will change my statement little bit. In my opinion IT GOD is top in...

Hi Sir I confirm you are absolutely right in this schema with minor change for ending condition :) SUM(R19:R27) should always = 1. (when R19, R21, R23, R25 and R27 are unlocked sum of all mentioned cells always equals 1 or in other words 100%) a) B19, B21, B23, B25, B27, R19, R21, R23...

Hi Sir :) In fact I have changed U10 by U11 prior uploading. When you have time please have a look into the original worksheet. You may see that conditional formatting is working, however cells B23 and R23 remain protected. So U10 and U11 are out of picture. PS1: Like in chess. Your move...

What to say whole issue is that I do not see why the code is not functioning. It is not giving any error massage. Even though code is not written in advance manner in principal should be working… Problem is that when R19 + R21 < 1 cells B23 and R23 should be unlocked. Here is the problem in...

Hi Sir I will follow your advice. In advance not sure if I will manage, but as an optimist person will try. Programming is not my field, but have to make it because have presentation on Monday... and above code is part of it Thanks and if no result will wait helppppppp we all need in this...

Hi there Thanks for support and help. I rushed to celebrate, the code is partly working... Probably it requires minor adjustment in VBA to make it right. Tried hard but no result... Unfortunately the code stops functioning for raw 23. In other words when following condition is true...

Hi there I had some cells merged. This was probably the reason macro to look up on above range. Looks it works now. Good base to build my case. Thanks a lot for your help Appriciated :)

Thanks a lot. Still getting problem on line [B19, B21, B23, B25, B27, R19, R21, R23, R25, R27].Locked = True Do you know what makes it to fail? Thanks again

I have the following VBA to build for a worksheet which by default is protected. For the following event VBA should be looking for values in specific cells and unprotect related cell: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Case 1 If cell “U10” is 0 then cells “B19”...

Thanks a lot Gio :)

Hi there Thanks for advice. After correction it gives error massage with following description. The element ‘qat’ in namespace http://schemas.microsoft.com/office/2009/07/customui has invalid child element ‘SharedControls’ in namespace Any suggestion. The way to fix it? Thanks

Could you please assist to correct the code? The following code gives the error massage.Any help is highly appreciated. To download Custom UI Editor visit the link http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/06/7293.aspx <customUI...

I see this is the reference Range("CauseCols").EntireColumn.Hidden = True How to define range for blank rowes between dynamic and fixed ranges. In other words to determine "CauseCols" range Thanks If you help me to fix then VBA comes complete