| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel Cut and paste
I have a excel file that I need to block the user from using the cut option
while in adding data to this file....Any ideas on how to do this? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel Cut and paste
On Feb 6, 11:40*am, RD wrote:
I have a excel file that I need to block the user from using the cut option while in adding data to this file....Any ideas on how to do this? Tell the user not to use the cut function, why would the user need to use it? |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel Cut and paste
Assumed data in range A1:A10 ( extend according to your need )
Ctrl + A | Ctrl + 1 | protection tab | uncheck locked & hidden option | Ok select the range A1:A10 | Ctrl + 1 | protection tab | check locked option | Ok Now go to tools | protection | protect sheet | password (optional) | ok Now only copy function will be available. On Feb 6, 11:40*pm, RD wrote: I have a excel file that I need to block the user from using the cut option while in adding data to this file....Any ideas on how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
![RD[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
