I'm working on an Excel workbook that is opened by a batch file, updates information, copy and pastes that information to PowerPoint, and closes itself after spending two minutes idle. This is all for an employee communication monitor that runs 24/7. However, I don't like that the Excel spreadsheet displays on the monitors for two minutes every time it opens and runs.
Right now I was using the bit of code below to minimize the workbook when it was done copying and pasting the information. It works fine for the monitors, but the application is not visible in the Taskbar. That might cause problems later on if somebody else needs to update anything in the spreadsheet.
Sub Workbook_Open()
...
Application.Visible = False
End Sub
Is there anyway to minimize the workbook while keeping the window visible in the taskbar?
Bookmarks