| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unable to protect cells in macro sheet b/c runtime error 1004
I inherited a spreadsheet that consists of 2 sheets. Sheet 1 has a macro
that sorts data from sheet 2. This is how it works: I enter "automotive" into Sheet 1 A2. Then I press Ctrl A. This command automatcally enters data into column B ( data from Sheet 2 that is associated with "automotive" in Sheet 2. I want to protect the entire Sheet 1 to protect the macros EXCEPT for A2. I am able to protect the sheet except for A2 (so people could enter data such as "automotive), but when I do the Ctrl A command, I get an error saying, "Run-time error 1004: The cell or chart you are trying to change is protected and therefore read only." How can I protect A2 in Sheet 1 without affecting the macros? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro runtime error 1004 with Autofilter | Excel Discussion (Misc queries) | |||
| runtime error 1004 HELP PLS | Excel Discussion (Misc queries) | |||
| runtime error 1004 | Excel Discussion (Misc queries) | |||
| Runtime Error '1004' | Excel Discussion (Misc queries) | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Threaded Mode
