1. D

    Update/run macro while minimized?

    A spreadsheet I'm working on is calculating days since an injury has occurred. I have a macro set up in my VBA editor that recalculates it every (x) minutes/hours/whatever I set it up as. When I paste the object into powerpoint to run on our warehouse displays it will refresh a few times, but...
  2. A

    Copy the entire row depending on a cell value but delete row if the cell value is changed/deleted

    Dear Experts, I found a macro from your forum which copies the entire row based on a cell value ("y") -Courtesy Mr. jindon MrExcel MVP. If we type "y" in column D, the entire row is copied & pasted to sheet 2. The code is as follows. The only point for clarification is how will the code change...
  3. I

    Background Autosave feature and excel htm modification

    Hi All Quick help required: I am using excel for dashboard presentation over intranet this main file needs to be updated after every 10 mins as we all know excel republish htm after saving file i want this saving process to be in background not by auto opening workbook again and saving it...

    auto refresh

    is there an auto refresh for a date value, maybe to force a refresh every 15 min or an hour?? in a cell i have the now() formula but does not auto update, you're help is greatly appreciated
  5. S

    Auto Refresh Pivot Tables

    Hi, I have several pivot tables in a workbook on separate worksheets. Rather than pasting the auto refresh pivot table code for each worksheet that has a pivot table, I would like a single code within the workbook that would refresh the pivot table everytime the worksheet is activated. I am...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...