Adding Checkboxes, But Macro still takes too long to execute

[Bob1980]

Good Morning All,

I have a macro that adds checkboxes to an excel worksheet. The problem is, it takes too long to load. When you run it, I see each individual checkbox being created. I figured this happens because the worksheet is activated. But, I have to activate the worksheet to add the checkbox.

Is there a way, or a method, of adding checkboxes without activating the worksheet? This way my "Application.ScreenUpdating = False" statement will apply.

Below is what my code looks like. thanks!

Please Login or Register  to view this content.

I'm going to try hiding the sheet and see if that works.

It's pretty straighforward.

Thanks for the help everyone!
Bob1980

[Bob1980]

Okay, that was a quick one! Hiding the sheet worked. I used the xlSheetVisible property so that the worksheet can still be manipulated. Below is an update to anyone who visits this thread.

Please Login or Register  to view this content.

thanks all.

Bob1980

[AlphaFrog]

You could also eliminate the .Select which is time expensive.

Please Login or Register  to view this content.

[nilem]

or

Please Login or Register  to view this content.

[Bob1980]

Oh I like both. I'll remove the .selection and use 7 & 8 as opposed to adding the FOR i value. I'll save time with both!

Thanks!
Bob1980