Results 1 to 7 of 7

Minimize Excel window but keep it visible in the Taskbar

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    Florida
    MS-Off Ver
    Office 2010
    Posts
    4

    Minimize Excel window but keep it visible in the Taskbar

    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?
    Last edited by kdsteinman; 06-30-2014 at 08:17 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to minimize the Excel window while the Macro is running ?
    By Ndt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2013, 03:56 PM
  2. minimize userform to windows taskbar
    By dulitul in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2013, 06:27 PM
  3. Minimize Excel to taskbar
    By D.S. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2006, 03:30 PM
  4. [SOLVED] Minimizing excel window grays it out on taskbar
    By Sysop in forum Excel General
    Replies: 0
    Last Post: 12-05-2005, 02:10 PM
  5. Replies: 3
    Last Post: 07-26-2005, 02:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1