Kako rotirati tekst u WORD-u

30/06/2015 § Leave a comment

  • Insert Text box
  • Format tab – no fill, no outline
  • Right click on text box
  • Format Shape
  • 3D rotation
  • X rotate for 180

– Same procedure for Word Art

 

Advertisements

Када ексел подели странице за штампу по сваком реду

30/06/2015 § Leave a comment

 

Проблем у драјверу за принтер. Заменити основни принтер са неким другим Adobe Printer, or CutePDF или неки други, затим подесити страницу како треба да изгледа, а потом вратити на основни (главни принтер).Ово се дешава зато што је документ сетован (у екселу 2007/2010 ) да му основни фајл, буде компатибилан са екселом 2003/97 (File save as Excel 2003/97).

Deletes a query table

30/06/2015 § Leave a comment

Sub Clear_QueryTable()

Dim qt As QueryTable
For Each qt In ActiveSheet.QueryTables
If qt.Refreshing Then qt.CancelRefresh
qt.Delete
Next
ActiveSheet.UsedRange.Clear

End Sub

_________
Source
https://www.safaribooksonline.com/library/view/programming-excel-with/0596007663/re661.html

Synopsis

Deletes a query table. If the query table is refreshing asynchronously, Delete causes an error. Deleting a query table does not remove data from cells on a worksheet—it just removes the ability to refresh those cells from their data source.

The following code deletes all of the query tables on the active worksheet and clears their data:

Delete All Shapes from the whole workbook using macro

30/06/2015 § Leave a comment

Sub Del_All_Shapes_WB()
Dim shp As Shape
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
For Each shp In ws.Shapes
shp.Delete
Next shp
Next ws
End Sub

_________
Source
http://www.mrexcel.com/forum/excel-questions/702797-delete-all-shapes-whole-workbook-using-macro.html

Where Am I?

You are currently viewing the archives for June, 2015 at RheXenoR.