| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock hidden cells
Is it possible to hide cells and stop them from being unhidden without a
password ??? Regards Mark |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock hidden cells
Hi Mark,
Hide the cells and then protect the worksheet "Mark Allen" wrote: Is it possible to hide cells and stop them from being unhidden without a password ??? Regards Mark |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock hidden cells
Mark
You cannot hide individual cells. Rows and columns, yes. Then protect the sheet with a password, which is very easy to crack. You can hide the contents of cells and what is seen in the Formula Bar. To hide cell contents, custom format to ;;; To hide formula bar contents, format to "locked" and "hidden" then protect the sheet with the easily-cracked password. Gord Dibben MS Excel MVP On Wed, 31 Dec 2008 07:17:00 -0800, Mark Allen wrote: Is it possible to hide cells and stop them from being unhidden without a password ??? Regards Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
| drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
| Lock a hidden worksheet | Excel Discussion (Misc queries) | |||
| How do I paste hidden cells and keep them hidden? | Excel Discussion (Misc queries) | |||
| How do I lock hidden columns? | Excel Worksheet Functions | |||
Linear Mode
