• 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. J

    Exit Sub If Invoice Exists

    Hello, On the Invoice Template sheet there is a shape "Save" which runs code to save the invoice as PDF and posts the information on the "Invoice Payments" sheet. Is there a way to exit the code if the invoice already exists? Also popup message saying "Invoice has already been saved, nothing...
  2. J

    Update Inventory Levels From Invoice

    Sorry I see it now. I assigned your code to a shape and ran it. Perfect!
  3. J

    Update Inventory Levels From Invoice

    Thanks but don't see any results. I do see that the lines were removed. Is there a new code that I am not aware of?
  4. J

    Update Inventory Levels From Invoice

    Hi, On the 'Stock Out' sheet I request macro for columns B, D, F, and H from the 'Invoice Template' sheet. When the code runs it will add rows to the table like I manually entered as an example. Can this be done please? Thank you
  5. J

    Unlock VBA

    I suppose this project (that I paid for) is a curve that life throws at you. Fart on it.
  6. J

    Unlock VBA

    Sorry for difficult issue.
  7. J

    Unlock VBA

    Hi, I forgot my password to edit VBA. Can someone please help? Thanks
  8. J

    Formulas for Zones

    Hi, I please ask for formulas to fill the schedule with the zone codes like I manually entered. Thank you
  9. J

    VBA to Put Zone Codes and Colors in Schedule

    Hello, Can VBA fill the Zone codes and colors for the time slots selected? I manually entered the desired results. Thank you
  10. J

    Formulas to Put Zone Codes and Colors in Schedule

    That's okay I will figure something out
  11. J

    Formulas to Put Zone Codes and Colors in Schedule

    Perhaps just the zone codes no colors thanks
  12. J

    Formulas to Put Zone Codes and Colors in Schedule

    Hello, Can formulas fill the Zone codes and colors for the time slots selected? I manually entered the desired results. Thank you
  13. J

    Open Workbook to Calendar sheet cell E2 Current Month Number

    Perfect thanks. I initially put the code in this workbook but that did not work. Sorry you did say to put in it a code module which I then did. Now it works perfectly. Have a blessed day and thanks for your help.
  14. J

    Open Workbook to Calendar sheet cell E2 Current Month Number

    Hi, What is the VBA code to open workbook to cell E2 on the Calendar sheet and make the cell value the current month number? Thank you
  15. J

    Delay Changing Month or Year First Time

    By adding this line to each button code it speeds up the response: Application.Calculate
  16. J

    Delay Changing Month or Year First Time

    Hi, When I click on the buttons to change the year or month there is an initial delay but after the first click it seems almost instant. Is this a normal expected result? Thanks
  17. J

    Highlight Today on Calendar

    Thank you that is a perfect solution.
  18. J

    Highlight Today on Calendar

    Please like I manually highlighted the calendar cells for June 20 which is today.
  19. J

    Highlight Today on Calendar

    I put it in Ask General Question and someone moved it to the VBA macros
  20. J

    Highlight Today on Calendar

    I don't believe this should be a VBA macro question.
  21. J

    Highlight Today on Calendar

    Hi, What is the format rule to highlight today on calendar? Thanks
  22. J

    Code for Calendar Buttons on Locked Sheet

    I figured it out with this version that I will provide here to help others.
  23. J

    Code for Calendar Buttons on Locked Sheet

    It never had the buttons or code. I added them.
  24. J

    Code for Calendar Buttons on Locked Sheet

    Hi, Does anyone know codes for putting on the buttons in the sheet? Thanks
  25. J

    VBA Place Current Month Number in Certain Sheet Cell

    Thanks so much it works great! At first I had the cell formatted as a date which is incorrect. I changed to general format and it works now.
Back
Top