Hiding automated spreadsheet activity

A

ajmplanner

I have an excelspreadshett with several sheets. I have automated the
spreadsheet with VB Excel. There is a lot of activity moving data from one
spreadsheet to another. In action, it is very disturbing to the user as the
code switches back and forth between sheets, across columns, etc. It gives a
fast flickering effect.

How can I hide this activity while hte code is executing?

Thanks in advance for a reply.
 
F

FSt1

hi
it might be helpful if you provide an example of the code your are using
that causes this disturbing code behavior but to take a wild guess, you might
try this
prior to the start of the disturbing code behavior...
application.screenupdating = false.
this might reduce the "flicker"
then at the end of the code
application.screenupdating = true
this might cause a small "blip" as the updates take

post back with more details if this doesn't work for you.

Regards
FSt1
 
A

ajmplanner

Thanks FST1. That is exactly what I was looking for. It hides all of the
macro activity. Happy New Year.
 

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

Top