形状仅以安全模式复制 [英] Shapes only copy in safe mode
问题描述
我有两台计算机,一台使用Excel 2010,另一台使用Excel 2013,复制工作表不会复制形状或图像。 例如,在运行后,新表上的形状不可见:
ActiveSheet.Shapes.AddShape msoShapeRectangle,50,50,100, 100
ActiveSheet.Copy之前:= ActiveSheet
如果我创建形状并手动复制工作表,也会发生同样的事情。
如果我以安全模式启动Excel(excel.exe / s)它可以工作。 我已尝试删除所有COM加载项并禁用Excel加载项,但无法使功能正常工作。 / s命令行参数做了哪些其他更改,我可以测试以确定
问题的原因?
提前致谢。
Clancy
有关此问题的更多信息......
开始with / automation不能解决问题,只能从/ safe或/ s开始。
希望有人可以帮忙解决这个问题!
Clancy
I have two computers, one with Excel 2010 and one with Excel 2013 where copying a sheet doesn't copy shapes or images. For example, the shape isn't visible on the new sheet after running:
ActiveSheet.Shapes.AddShape msoShapeRectangle, 50, 50, 100, 100 ActiveSheet.Copy Before:=ActiveSheet
The same thing happens if I create the shape and copy the sheet manually.
If I start Excel in safe mode (excel.exe /s) it works. I have tried removing all COM Add-ins and disabling Excel add-ins, but can't get the functionality to work. What other changes does the /s command line parameter make that I can test to determine the cause of the problem?
Thanks in advance.
Clancy
Further information on the issue...
Starting with /automation doesn't fix the problem, only starting with /safe or /s.
Hope someone can help with this!
Clancy
这篇关于形状仅以安全模式复制的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!