topic Re: help require where with the help scripting/macro where we can change the font, colour, width, etc of any object(text, chart, etc in QlikView https://community.qlik.com/t5/QlikView/help-require-where-with-the-help-scripting-macro-where-we-can/m-p/450342#M1162429 <HTML><HEAD></HEAD><BODY><P>Hi, Have no idea for changing the color but here is the code for changing the font size. sub changeFont&nbsp;&nbsp;&nbsp;&nbsp; set sheet = ActiveDocument.ActiveSheet&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for i=0 to sheet.NoOfSheetObjects-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set sheetObject = sheet.SheetObjects(i)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; font = sheetObject.GetFrameDef.Font&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; font.PointSize1000 = font.PointSize1000 + 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheetObject.setFont font&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; next end sub Regards. Siva Sankar</P></BODY></HTML> Wed, 19 Dec 2012 07:23:16 GMT Siva_Sankar 2012-12-19T07:23:16Z help require where with the help scripting/macro where we can change the font, colour, width, etc of any object(text, chart, etc https://community.qlik.com/t5/QlikView/help-require-where-with-the-help-scripting-macro-where-we-can/m-p/450341#M1162427 <HTML><HEAD></HEAD><BODY><P>Hello Friends/Guru's/Master,</P><P></P><P></P><P>I want to change the color, font, background color, width, height, etc of any object (text object, chat object, etc) by scripting/macro.</P><P></P><P>It will be great help if anybody show the way out to achive my requirement by providing me small QVW file example.</P><P></P><P>Awaiting for response <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P>Thanks in Advance</P><P></P><P></P><P>Shantanu</P></BODY></HTML> Wed, 19 Dec 2012 06:12:52 GMT https://community.qlik.com/t5/QlikView/help-require-where-with-the-help-scripting-macro-where-we-can/m-p/450341#M1162427 shantanu73 2012-12-19T06:12:52Z Re: help require where with the help scripting/macro where we can change the font, colour, width, etc of any object(text, chart, etc https://community.qlik.com/t5/QlikView/help-require-where-with-the-help-scripting-macro-where-we-can/m-p/450342#M1162429 <HTML><HEAD></HEAD><BODY><P>Hi, Have no idea for changing the color but here is the code for changing the font size. sub changeFont&nbsp;&nbsp;&nbsp;&nbsp; set sheet = ActiveDocument.ActiveSheet&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for i=0 to sheet.NoOfSheetObjects-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set sheetObject = sheet.SheetObjects(i)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; font = sheetObject.GetFrameDef.Font&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; font.PointSize1000 = font.PointSize1000 + 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sheetObject.setFont font&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; next end sub Regards. Siva Sankar</P></BODY></HTML> Wed, 19 Dec 2012 07:23:16 GMT https://community.qlik.com/t5/QlikView/help-require-where-with-the-help-scripting-macro-where-we-can/m-p/450342#M1162429 Siva_Sankar 2012-12-19T07:23:16Z