| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 1004
Hi
I have a macro the protects and unprotect a workbook. When I manually unprotect a workbook and try to do something I get the following message: "Run Time Error 1004: The cell or chart you are tryint to change is protected and therefore read-only. To modify a protect cell or chart, first remove protection using the Unprotect sheet command( Tools menu, Protection submenu). You may be prompted for a password" Would anyone have any ideas why this is happening? Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run Time Error 1004
This isn't workbook protection. It's worksheet protection.
So tools|Protection|Unprotect Worksheet (manually) or add the equivalent in your code. "Gregc." wrote: Hi I have a macro the protects and unprotect a workbook. When I manually unprotect a workbook and try to do something I get the following message: "Run Time Error 1004: The cell or chart you are tryint to change is protected and therefore read-only. To modify a protect cell or chart, first remove protection using the Unprotect sheet command( Tools menu, Protection submenu). You may be prompted for a password" Would anyone have any ideas why this is happening? Greg -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run Time Error 1004
Dave Peterson wrote: This isn't workbook protection. It's worksheet protection. So tools|Protection|Unprotect Worksheet (manually) or add the equivalent in your code. The error message comes up after I have done that. Greg |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run Time Error 1004
I don't have another guess.
"Gregc." wrote: Dave Peterson wrote: This isn't workbook protection. It's worksheet protection. So tools|Protection|Unprotect Worksheet (manually) or add the equivalent in your code. The error message comes up after I have done that. Greg -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
| Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
| run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
| Run time error '1004': Generaol ODBC error | Excel Programming | |||
| Application Run Time Error 1004 and Stack Error | Excel Programming | |||
Hybrid Mode
