1 VBA Project and 1 VBA Module running way too slow! Please Help!

[Asphalt_Cowboy]

I have this VBA Project that seems to take forever to run. Its a spell check project that Shows a message in a popup box then after closing that it runs spell check on all 3 worksheets after unlocking the page its on then it goes back and re-locks them. If it doesn't find spelling errors it just seems to take forever!

Please Login or Register  to view this content.

Also here is a module i run when I reopen the workbook that seems to be taking too long also. It auto sorts everything first by column 1 and then by column 2 on all 3 sheets then it goes back and select the top left (unlocked) cell of the first page. After this it shows a popup message but it seems to take awhile to get to that popup message.

Please Login or Register  to view this content.

Any help to speed these 2 codes up would be appreciated
The 2nd code (AutoOpen) isn't really that slow its okay just whoever looks at it maybe they see something i could have done better.

[ragulduy]

I guess in the spellcheck one you could try turning off calculations as well

Please Login or Register  to view this content.

Also, I love that your spellcheck macro has a spelling error in it.

[Asphalt_Cowboy]

I will try that thanks hopefully it speeds things up. I never noticed the spelling error lol. I just made that real fast troed it and posted it here.

[Izandol]

With Excel 2013 the changing of sheet protection is much slower than it was in other versions.

[Asphalt_Cowboy]

yudlugar you code you put up above doesnt actually spell check on any pages