Slow and Unsure Why

tzw1378

Active Member
Joined
Jan 16, 2014
Messages
259
Hello,

There's a shared workbook with many, many tabs. I created a new table of contents worksheet with many text boxes where you can click a text box with a worksheet name and it will change that sheet from VeryHidden to Visible, select it, and then VeryHide the former Table of Contents sheet so that you're focused on only the sheet you selected.

Then I added a button to the ribbon to do the reverse. Show the Table of Contents and hide the former worksheet you were working on. Pretty simple VBA.

This is a great way to navigate a workbook with so many sheets. Upon comparison, however, some users are reporting that clicking around various sheets now seems to have a lag.

This is odd because I have no selection change macros or anything else that I thought would cause any sort of lag. I've saved this file as a Binary workbook.

What may be causing a lag? I'm not sure and I'd be happy to add any clarification that may be needed.

I look forward to a fruitful discussion and thank you all in advance.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

tzw1378

Active Member
Joined
Jan 16, 2014
Messages
259
I understand there may not be one explicit answer or a set of answers, for that matter, to this question.

And that's okay! Any general feedback to this post would be most appreciated.

Thank you again.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,911
Messages
5,598,819
Members
414,260
Latest member
joishe

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top