dissable some button or range of cell for a prticular sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 Format>Cells>Protection>remove check mark from locked.
Tools>Protection>Protect 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)
 
my friend it is not what i am looking for
can u please check any template File>new>template
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
 
Back
Top