Excell and VLisual Basic?

Question

My VB program locks up .I have an Excell workbook with 100 worksheets.\
I want to place the word"control"

on each sheet

My sheets are not in exact numerical order.

I type
For t = 1 to sheets.count

The program locks up after a few sheets

Answer 1

If this is a one time update, try doing a group update.

Click the leftmost worksheet tab, and while holding the shift key, scroll to the rightmost worksheet tab and click the tab. This should highlight all tabs.

Then enter the word Control in the desired cell. That should update all worksheets.

But why 100 worksheets??!! My guess is that you should re-think your spreadsheet design.