jrobin5881
Technical User
I have written a macro that runs over several workbooks and several thousand rows of data. Here's the issue: One of the workbooks has 19 sheets in it and when my macro opens this particular workbook it stalls for about two seconds or so while it opens all of the sheets in what seems to be the code section(I think..). The reason I think it's being caused by this spreadsheet is due to it happening to me when I "View Code" on this sheet all of the worksheets open up in the Project viewer window and it takes time.
Not a big issue overall just annoying and I'm figuring there has to be a better way.
Not a big issue overall just annoying and I'm figuring there has to be a better way.