View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gregc. Gregc. is offline
external usenet poster
 
Posts: 12
Default 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