RT, word to generate statistical figure, Excel has been flashing until completion of the word formation? How to solve?

CodePudding user response:

I tried it on, the following sentence can Excel hidden:

 
AChart. ChartData. Workbook. Application. The Visible=False 

Why do you give commented out? Wrong location result is bad?

CodePudding user response:

I'll put in the corresponding position, then there is no hiding, where are you?

CodePudding user response:

These three lines, you can try to put the three lines of code in a process, then F5 to run once, can see hidden:

 
Dim aChart as chart 
Set achart=selection. Inlineshaptes. Addchart (xl3dcolumnclustered, selection range). The chart 
AChart. ChartData. Workbook. Application. The Visible=False 

If not sure is the third line of hidden, can be commented out in the third row, run see again can not hide.

CodePudding user response:

The

reference 3 floor milaoshu1020 response:

these three lines, you can try to put the three lines of code in a process, then F5 to run once, can see hidden:

 
Dim aChart as chart 
Set achart=selection. Inlineshaptes. Addchart (xl3dcolumnclustered, selection range). The chart 
AChart. ChartData. Workbook. Application. The Visible=False 

If not sure is the third line of hidden, can be commented out in the third row, run see again can not hide.

Plus, also not make

CodePudding user response:

Because Excel open speed is slow, so there will be a period of time after open not hidden, I didn't also the way of this kind of circumstance.