Minimizing a workbook or worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've implemented one of the progress bars suggested in the threads here. I
am looping through a named range and as the process is running, the rows are
changing as expected. What I need is a way to minimize the current sheet or
workbook (setting Visible=false breaks my code). I searched the VBA help for
a way to minimize the sheet but cant find it. How can minimize the sheet or
workbook?
 
With ActiveWindow
.WindowState = xlMinimized
End with

or for the application

application.WindowState = xlMinimized


to restore xlNormal
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a fancy way to open a workbook in a minimized window stat 2
Minimize worksheet but keep userform visible 2
VBA "sheet" NOT to minimize while working on worksheet 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
minimize workbook 4
VBA - need to minimize Excel from UserForm 3
Need code to close minimized workbooks in BeforeClose event 3
minimize just opened workbook window 1

Back
Top