| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell protection short cut button
I am using 2007 now insteat of 2003. I cant find a short cut button to lock
and unlock a cell. There was one in excel 2003 but as yet I can't find it in 2007. I know I can go into Format Cell and protection but I like the short cut button. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell protection short cut button
You can add it to the QAT -- right-click any command & select Customize QAT,
select All Commands from the top dropdown, scroll to Lock Cell, and click Add. Now it appears in the QAT. HTH Bob Umlas Excel MVP "Bert" wrote: I am using 2007 now insteat of 2003. I cant find a short cut button to lock and unlock a cell. There was one in excel 2003 but as yet I can't find it in 2007. I know I can go into Format Cell and protection but I like the short cut button. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Short cut to refer a cell in diference worksheet | Excel Discussion (Misc queries) | |||
| Button properties blank: protection problem? | Excel Discussion (Misc queries) | |||
| Global Sheet Protection and a Button | Excel Discussion (Misc queries) | |||
| Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
| Command Button protection problems???? | Excel Worksheet Functions | |||
Linear Mode
