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.
Contents
[hide]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