Hypsetpages - works slower when excel workbook contains more smartview planner form sheets

Summary

Hypsetpages - works slower when excel workbook contains more smartview planner form sheets

Content

Hi all,

I use the following macro smartview code to set the dimension. When my workbook contains only one planner form sheet, this below macro runs fast. But when you add more planner form sheets to the workbook, the macro gets slower. I noticed that let's say workbook contains 10 planner form sheets, the macro wil repeat 10 times this below code to only change the dimension in worksheet  " Sheets("01- CS HC BB") ". So if you apply this below code for the 10 worksheets, it will take 100 (10 x 10) actions to apply the below macro code for those