• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    VBA visible columns aligned in the centre (full screen mode)

    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...
  2. G

    VBA target cells values to lock / unlock dependent cells

    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”...
  3. G

    SharedControls - code for Custom UI Editor error to fix

    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...
  4. G

    VBA to combine dynamic and fixed ranges to set print area

    Could you please help me to combine dynamic range and fixed range in the print area? I used the VBA code to set print area for dynamic range. The table goes from A1 to max M313. In addition I need to add into printing area fixed range(“A315:M321”) Here is the code: Private Sub...
  5. G

    VBA Drop down list based on dynamic Lists dependent on ref list attributes

    In the worksheet “PB” range (“C14:C313”) contains drop down list “Account”. In the worksheet “CA” range (“B3:B1000”) is dynamic List named as “Account” In the same sheet “CA” range (“D3:D1000”) represents account rules assigned to each account In total there are 8 rules as listed below...
Back
Top