Search:

Type: Posts; User: ImpetuousRacer; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    74

    VBA to copy to clipboard on MAC?

    I have Excel 2019 (16.29.1)

    I do not see an option to insert a userform or enable object library 2.0.

    Is there a way in Excel for Mac to setup a macro to copy cell value to clipboard? Thanks...
  2. VBA to update SQL Statement in Power Query?

    I'm on Office 365.

    I created an ODBC connection to Google BigQuery. After selecting the data source as Google BigQuery, I expand "Advanced Options" and there is an option for "SQL Statement...
  3. Replies
    22
    Views
    59,990

    Re: Alt-F11 to open VBE has stopped working!

    Thanks, this saved my hide, I was pulling my hair out!
  4. Re: Excel 2013 - No Trusted Publisher Prompt? How do I become trusted?

    Anyone know how to do this same process with a DMG package for a Mac?
  5. Re: Excel 2013 - No Trusted Publisher Prompt? How do I become trusted?

    Awesome! The second link had the command line I needed.

    The rest of the information I figured out through various sources. I've summed it up below as I figured I it could help others...
    ...
  6. Excel 2013 - No Trusted Publisher Prompt? How do I become trusted?

    I have Excel 2013 and have paid for and received a Digital code-signing certificate from GlobalSign.
    When I am in the visual basic editor, I go to Tools > Digital Signature and sign with my digital...
  7. Re: How to Sort by Date on "blank cells"?

    Thanks ajetrumpet for the help and the reasoning of everything. Much Appreciated! Using the date format "yyyy/mm/dd" will work for my sorting needs.
  8. How to Sort by Date on "blank cells"?

    Ok, so I have data that is all dates in column A that pulls from another source:

    I used this formula in column B to suppress errors:

    =IF(ISERROR(VALUE(A1)),"",VALUE(A1))
    Therefore, This...
  9. NA errors when linking to a protected workbook? How to fix?

    Ok, I'm working with Excel 2007. I have a summary sheet that is .xls and it links to about 60 other xls workbooks. All workbooks are based off the same template. The cell I'm referencing is on a...
Results 1 to 9 of 9