Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dissable some button or range of cell for a prticular sheet
Dear user
As u can see in Templates provided with MS excel some button , functions and range of cell is disable for that particular sheet the user is restricted to perform only specific task. waiting deliberately for replies. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dissable some button or range of cell for a prticular sheet
Hi
Perhaps you mean locking cells. All cells are locked by default, but that only becomes invoked if you set Protection on for the sheet. Select the range of cells that you want the user to be able to enter data and FormatCellsProtectionremove check mark from locked. ToolsProtectionProtect Sheet The user will now only be able to enter values in the cells from which you removed protection. (You don't have to set a password, but if you do make sure you remember it - although it is not totally secure as there are many publicly quoted methods for Password removal) -- Regards Roger Govier "NAEEM" wrote in message ... Dear user As u can see in Templates provided with MS excel some button , functions and range of cell is disable for that particular sheet the user is restricted to perform only specific task. waiting deliberately for replies. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
dissable some button or range of cell for a prticular sheet
my friend it is not what i am looking for
can u please check any template Filenewtemplate u will see the cells completly disable even u cant click no them and some formating tools are also dissabled awaiting reply best regards M. Naeem "Roger Govier" wrote: Hi Perhaps you mean locking cells. All cells are locked by default, but that only becomes invoked if you set Protection on for the sheet. Select the range of cells that you want the user to be able to enter data and FormatCellsProtectionremove check mark from locked. ToolsProtectionProtect Sheet The user will now only be able to enter values in the cells from which you removed protection. (You don't have to set a password, but if you do make sure you remember it - although it is not totally secure as there are many publicly quoted methods for Password removal) -- Regards Roger Govier "NAEEM" wrote in message ... Dear user As u can see in Templates provided with MS excel some button , functions and range of cell is disable for that particular sheet the user is restricted to perform only specific task. waiting deliberately for replies. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
dissable some button or range of cell for a prticular sheet
Thanks friend u r right
it works as told best regards M Naeem "Roger Govier" wrote: Hi Perhaps you mean locking cells. All cells are locked by default, but that only becomes invoked if you set Protection on for the sheet. Select the range of cells that you want the user to be able to enter data and FormatCellsProtectionremove check mark from locked. ToolsProtectionProtect Sheet The user will now only be able to enter values in the cells from which you removed protection. (You don't have to set a password, but if you do make sure you remember it - although it is not totally secure as there are many publicly quoted methods for Password removal) -- Regards Roger Govier "NAEEM" wrote in message ... Dear user As u can see in Templates provided with MS excel some button , functions and range of cell is disable for that particular sheet the user is restricted to perform only specific task. waiting deliberately for replies. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADD A BUTTON TO A CELL TO DELETE A RANGE OF CELLS? | Excel Discussion (Misc queries) | |||
Button linking to another cell and sheet | Links and Linking in Excel | |||
Same cell range on different sheet | Charts and Charting in Excel | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions |