Don't Move or size with cells
Have written a code to produce a spreadsheet in excel from AutoCAD.
Within that code I have inserted an image.
Is there a way in VBA to set the properties of this image so that it is set to "Don't Move or size with cells".
Any help would be greatly appreciated.
How's this do for you?
Obviously change "Picture 2" to the name of your picture.
Sub Streng() ActiveSheet.Shapes("Picture 2").Placement = xlFreeFloating End Sub
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Thanks for your help that worked a treat
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks