Comments on: How to enable and disable macros in Excel

Like almost any technology, macros can be used for both good and evil. Therefore, in Microsoft Excel, all macros are disabled by default. This tutorial covers different ways to enable macros in Excel and explains potential risks associated with that. Continue reading

Comments page 2. Total comments: 37

  1. How do you open macro (Solver) in XLAM format
    Thanks.

  2. I am trying to run Worksheetfunction.search and Worksheetfunction.find in VBA (Microsoft 365) but get "unable to get the Match property of the WorksheetFunction class". Is there an add-in I need?
    BTW: Worksheetfunction.Text works.

    Thanks.

    1. The said function you are looking for would be the:

      Find

      function, which is an inbuilt function of VBA itself.
      You do not need the Application.WorksheetFunction.Find function in order to proceed with the find task on a worksheet.

      Refer : https://docs.microsoft.com/en-us/office/vba/api/excel.range.find

  3. In My computer Macro security option and recording and other option is disbale.i dont know why even instaled new Office

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)