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

Recent content by ThrottleWorks

  1. ThrottleWorks

    Impact of ChatGPT or similar kind of tools for people working as VBA developers

    Hi, Hope you are doing good. May I request experts here to share their views about ChatGPT or similar platforms in context with VBA developers. I started using ChatGPT around three months ago. I found it very useful for coding, agree we need to edit the code but most of my questions at least...
  2. ThrottleWorks

    Emails undelivered when created by macro for some users

    Hi, One important update from my side. It is possible that macro was not tested from sending emails with different users. What I meant is, person A creates email, saves in draft, person B from his system tries to send email. This was never tested before, when it was tested, it was found that it...
  3. ThrottleWorks

    Emails undelivered when created by macro for some users

    Hi @Marc L thanks a lot for the help. My confusion, this was working good till few days ago. Stopped working all of a sudden.
  4. ThrottleWorks

    Emails undelivered when created by macro for some users

    Hi, This is an existing macro. I have not developed this macro. This macro created email drafts and save it in draft folder Drafts are saved in group mailbox, multiple people have access to this group mailbox If am the user, I run the macro, macro creates drafts, I send them manually, no issue...
  5. ThrottleWorks

    Need help for CHOOSECOLS formula in Excel

    Thanks @pecoflyer for the help. I was thinking that upgrade might be the solution but was not sure about it. Your guidance helped me, now I can proceed accordingly. :)
  6. ThrottleWorks

    Need help for CHOOSECOLS formula in Excel

    Hi @pecoflyer thanks for the help. Mine is in About Excel, it is showing Version 1908 (Build 11929.21008 Click-To-Run). Windows 10 enterprises. Have a nice day ahead. :)
  7. ThrottleWorks

    Need help for CHOOSECOLS formula in Excel

    Hi, Hope everyone is doing fine. I need help for CHOOSECOLS formula. I have received one file, this file has 'CHOOSECOLS' formula in it. However, when I open the file, the formula is reflecting as =_xlfn.CHOOSECOLS(_xlfn._xlws.FILTER(FX!$A$2:$T$50,FX!$N$2:$N$50<0,""),1,4,5,8,10,11,12,14,16)...
  8. ThrottleWorks

    How to prevent user from pasting data in a range, protected range won’t work

    Hi @Marc L thanks a lot for the help. Have a nice day ahead. :)
  9. ThrottleWorks

    SECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted.

    Hi @rlv01 thanks a lot for the help. Have a nice day ahead. :)
  10. ThrottleWorks

    How to export cell change event code from one worksheet to another copied worksheet

    Hi @Debaser thanks a lot for the help. Below code is working good for me. Do not know why, my previous code was not copying related modules hence I got confused. Have a nice day ahead. :) Public Sub CopySelectedSheets() ActiveSheet.Copy After:=Sheets(Sheets.Count) ActiveSheet.name = "Foo" End Sub
  11. ThrottleWorks

    How to prevent user from pasting data in a range, protected range won’t work

    Hi, I have a worksheet. In range E11:E30 I have validation as Yes, No. User need to select each cell as either Yes or No. User should not simply copy paste values in these cells. How can I prevent this. Motive is user should select Yes or No in each cell based on their understanding. Protected...
  12. ThrottleWorks

    How to export cell change event code from one worksheet to another copied worksheet

    Hi, I have a macro workbook. There are normal modules written in this book and some are written for cell change event. Cell change event codes are written in the particular worksheet and these are running fine. Issue is, I need to create multiple copies of this worksheet as per the user...
  13. ThrottleWorks

    SECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted.

    Hi, One of the user is facing below issue while running the macro. Other users from same team are able to run this macro. I was not able check the actual macro, this was only verbally communicated. Excel is showing below message on ribbon when macro is opened. SECURITY RISK Microsoft has blocked...
  14. ThrottleWorks

    Need help for Pivot Tables

    Thanks for the help @AlanSidman , have a nice weekend. :)
  15. ThrottleWorks

    Need help for Pivot Tables

    Hi Experts, I need your help. Please help me if you get time. I have a worksheet. This worksheet has n number of pivots. I want to extract base data of each pivot table in a new worksheet. Just like how we do manually, we select last cell of pivot table and double click on it to see base data...
Back
Top