Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends/Guru's/Master,
I want to change the color, font, background color, width, height, etc of any object (text object, chat object, etc) by scripting/macro.
It will be great help if anybody show the way out to achive my requirement by providing me small QVW file example.
Awaiting for response
Thanks in Advance
Shantanu
Hi, Have no idea for changing the color but here is the code for changing the font size. sub changeFont set sheet = ActiveDocument.ActiveSheet for i=0 to sheet.NoOfSheetObjects-1 set sheetObject = sheet.SheetObjects(i) font = sheetObject.GetFrameDef.Font font.PointSize1000 = font.PointSize1000 + 1000 sheetObject.setFont font next end sub Regards. Siva Sankar