MrExcel Publishing
Your One Stop for Excel Tips & Solutions

protect worksheet vs. application.Goto Reference


Posted by Jim on January 04, 2002 9:33 AM

Hi group,

I have a worksheet w/ quite a bit of:

Application.Goto Reference:=Range("A49"), Scroll:=True

Now when i protect the sheet i get:

Run-time error'1004':
Method'Goto' of object'_Application' failed

Does anyone know a way around this?

Thanks, Jim


Posted by Jim on January 04, 2002 10:58 AM

This seems to do it:

Sheets("sheet1").Unprotect password:= "your pw"
Application.Goto Reference:=Range("A49"), Scroll:=True
Sheets("Sheet1").Protect password:="your pw"

Jim