Excel图片工具格式vba
在 Excel 和Word 2007 有一个图片工具选项卡，当您插入图片或剪贴画时，功能区中会显示一个图片工具选项卡，并且有智能艺术。有没有办法在 vba 中操作这些对象和设置（例如透明度、位置、效果等）。宏似乎也不适合我。
In excel & word 2007 there is a picture tools tab that shows up in the ribbon when you insert a picture or clip art and there is the smart art. Is there a way to manipulate these objects and settings (e.g. transparency, position, effects etc) in vba. A macro doesn't seem to work for me either.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我知道在 Excel VBA 中（我的经验是在 2007 年之前），您可以通过
Shape对象操纵图像的许多方面。探索Shape对象的一个好方法是在尝试操作图像时记录一个宏，然后查看它创建的 VBA 代码以了解您做了什么。这并不总是能完美地发挥作用，但这是一个很好的开始方式。另外，您可能有兴趣查看我给相关问题的答案关于在 Excel 中的单元格之间移动图像的问题。
我不确定仅使用
Shape对象可以操作图像的多少个方面，但值得一看。I know that in Excel VBA (my experience is prior than 2007), you could manipulate many aspects of images via the
Shapeobject. A good way to explore theShapeobject is to record a macro while you try to manipulate the image and then look at the VBA code it created to see what you did. This doesn't always work perfectly, but it's a great way to start.Also, you might be interested in checking out the answer I gave to a related question about moving images between cells in Excel .
I'm not sure how many aspects of an image you can manipulate just with the
Shapeobject, but it's worth taking a look.目前，我不认为有一种方法可以在 Office 2007 中使用代码来操纵这些图片方面。
如果有人有更好的答案，我会将其标记为已接受。
For now I don't believe there is a way to manipulate with code these picture aspects in office 2007.
If anyone out there has a better answer, I will mark it as accepted.
如果您想更改实际显示的图片，这将有所帮助。这是非 VAB 的东西，但该技术值得了解
此处
This will help if you want to change the actual picture displayed. It's non-VAB stuff, but the technique is worth knowing about
here