My toggle hide question

  • Thread starter Thread starter Robert Hustead
  • Start date Start date
R

Robert Hustead

Sorry, I was mistaken. The macro is working and only affecting the the
rows I wanted it to, but the sheet flutters and takes a while to
close/open. I am going to try it on a clean spreadsheet.
 
Hi Robert
you may consider using the line
Application.screenupdating = false
at the beginning of your macro

and the line
Application.screenupdating = True
at the end of the macro
 

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

hide & unhide toggle button 3
Toggling xlVeryHidden 8
Toggle for Macro 5
toggle button in excel 4
Hide/Unhide Toggle 3
Error with toggle code 2
VBA code to toggle hiding a serie (and relative legend) in a chart 3
Toggle Event - 2 Commands on 1 Button 1

Back
Top