Tabs Flickering

Put your best Excel related tips and tricks here.
Forum rules
This is the place to put all of your Excel Tips & Tricks.
ahansen
Posts: 20
Joined: Fri Feb 12, 2010 8:01 am

Tabs Flickering

Postby ahansen » Wed Jul 10, 2013 1:23 pm

I remember someone telling me how to do this once, but I don't remember. I don't want the workbook to flip thru all the tabs as it is calculationg (visually). I still want all the tabs to update, just not flip thru each tab on the screen. For instance, I have a report with an options tab. When I click refresh, I don't want it to switch to the options tab and then back. Anyone know how to do this?

User avatar
fhilton
Posts: 1457
Joined: Fri Dec 14, 2007 4:43 pm

Re: Tabs Flickering

Postby fhilton » Wed Jul 10, 2013 1:35 pm

I don't believe there is any way to do this. What is the actual problem you need to solve by having it not show each sheet during the report run?

Regards,
Hughes


Return to “Excel Tips & Tricks”

Who is online

Users browsing this forum: No registered users and 1 guest