sponsored ads

How to lock table size in PowerPoint 2007?

sponsored ads

I don´t know how to lock a table, the problem is so I neet put a specific table size and lock. This table update its information with an object. Asked Jun, 12 2012
add commentflag 

sponsored ads

answer this question

The fastest way to adjust the width of columns and the height of rows on your PowerPoint slides is to drag the mouse PowerPoint even lets you adjust the size of the table itself:

Change the size of a column or row: Move the pointer onto a gridline or border, and when the pointer changes into a double-headed arrow, start dragging.

You can also go to the (Table Tools) Layout tab and change the measurements in the Cell Size boxes to change the width of a column or the height of a row. The measurements affect entire columns or rows, not individual cells.

A table: Drag a selection handle on a side or corner. You can also go to the Layout tab, click the Table Size button (if necessary), and enter inch measurements in the Height and Width text boxes. Click the Lock Aspect Ratio check box to keep the table’s proportions as you change its height or width.

Read more: http://www.dummies.com/how-to/content/how-to-change-the-size-of-a-powerpoint-2007-tables.navId-405700.html#ixzz1Hmg7W0NY Answered Apr, 05 2011
vote up 1 vote down

1.Click the (Table Tools) Design tab.
The Design view opens.
2.Open the Table Style gallery.
Once there, move the pointer over table style choices to live-preview the table
3.Select a table style.
To remove a table style, select Clear Table on the bottom of the Table Styles gallery.
Reference site: http://www.dummies.com/how-to/content/how-to-design-a-table-with-a-powerpoint-2007-table.html Answered Apr, 10 2011
vote up 1 vote down

I am trying to do the same thing and came across the following code. This code does work but I need to see if anyone can help enhance it to accomplish what I am looking to do.

First I have multiple pivot tables in a work book and I would like to have the code run automatically when they open the workbook and restrict them from changing any of the pivot tables.

Second the code below does not lock the row fields from being moved and I would like to lock them as well.

The only thing I want the user to be able to do is use the filters and have the ability to use the drill down function. Also, the Pivot Table needs to be able to be refreshed.

Thanks
George

Sub AllowPivotTable()
'pivot table tutorial by contextures.com
Dim pt As PivotTable
Dim pf As PivotField
Set pt = ActiveSheet.PivotTables(1)
With pt
.EnableWizard = True
.EnableDrilldown = True
.EnableFieldList = True 'Excel 2002+
.EnableFieldDialog = True
.PivotCache.EnableRefresh = True
For Each pf In pt.PivotFields
With pf
.DragToPage = True
.DragToRow = True
.DragToColumn = True
.DragToData = True Answered Jun, 18 2011
vote up 1 vote down

Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
Create one

Options

sponsored ads

Download related software from AFC

Mp3 AddIn for PowerPoint 1.0

Last Updated: Mar 16, 2011
License: Freeware
Filesize: 1.06MB

Continue to downloadPower by Afreecodec.com