XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "Using Grids with Protected Worksheets"

(Made the link to the Microsoft page more specific)
Line 4: Line 4:
 
The Grid may be placed directly on the worksheet that is to be protected. To do this, follow these steps:
 
The Grid may be placed directly on the worksheet that is to be protected. To do this, follow these steps:
 
* On the {{Menu|Grid Properties|Appearance}} tab, deselect {{Menu|Apply formatting}} and {{Menu|Merge repeating cells}}
 
* On the {{Menu|Grid Properties|Appearance}} tab, deselect {{Menu|Apply formatting}} and {{Menu|Merge repeating cells}}
* Set all the Grid cells to be unlocked. See [http://office.microsoft.com/en-us/excel-help/lock-or-unlock-specific-areas-of-a-protected-worksheet-HA010096837.aspx this Microsoft article] for details on how to lock and unlock specific cells.
+
* Set all the Grid cells to be unlocked. See [http://office.microsoft.com/en-us/excel-help/lock-or-unlock-specific-areas-of-a-protected-worksheet-HA010096837.aspx?CTT=3#_Toc296590751 this Microsoft article] for details on how to lock and unlock specific cells.
 
* If the Grid can be edited by drilling or other member selection methods, also unlock cells to accommodate the potential expansion.
 
* If the Grid can be edited by drilling or other member selection methods, also unlock cells to accommodate the potential expansion.
 
* Protect the sheet. At least the following options must be allowed:
 
* Protect the sheet. At least the following options must be allowed:

Revision as of 14:41, 4 July 2012

XLCubed Grids can coexist with protected worksheets in several ways.

Using the Grid on the protected worksheet

The Grid may be placed directly on the worksheet that is to be protected. To do this, follow these steps:

  • On the Grid Properties > Appearance tab, deselect Apply formatting and Merge repeating cells
  • Set all the Grid cells to be unlocked. See this Microsoft article for details on how to lock and unlock specific cells.
  • If the Grid can be edited by drilling or other member selection methods, also unlock cells to accommodate the potential expansion.
  • Protect the sheet. At least the following options must be allowed:
    • Format cells
    • Format columns
    • Format rows

If Format columns and Format rows protection are desired, then Grid Properties > Behaviour > Resize columns/rows after refresh must be disabled.

Placing the Grid on a non-protected worksheet

The Grid can be placed on a non-protected worksheet, and the data brought to the protected sheet by using either:

  • The Camera tool (see this post for details)
  • Formulae

Alternatives

See Also