Strange Worksheet Protection
 

Hi,

Somehow I seem to have assigned a macro to a worksheet. What happens is
that when I protect the sheet, the cursor changes to a hand and if I
can click anywhere on the sheet it runs a macro. The macro it tries to
run is assigned to a form button at the top of the sheet. I have
deleted the button to see if this would change anything but it hasn't.
I have checked the worksheet code and there isn't any. Like I said this
only happens when the sheet is protected. Any ideas greatly
appreciated.

Cheers

James

Strange Worksheet Protection
 

Hi,
You have a zero-height object in that sheet.
Even if cells are deleted, objects are not deleted.
Unprotect the sheet and select all objects(Edit Goto Special Objects).

--
HTH,
okaizawa

wrote:
Hi,

Somehow I seem to have assigned a macro to a worksheet. What happens is
that when I protect the sheet, the cursor changes to a hand and if I
can click anywhere on the sheet it runs a macro. The macro it tries to
run is assigned to a form button at the top of the sheet. I have
deleted the button to see if this would change anything but it hasn't.
I have checked the worksheet code and there isn't any. Like I said this
only happens when the sheet is protected. Any ideas greatly
appreciated.

Cheers

James

Strange Worksheet Protection
 

Hi,

Yeah that did the trick it was hiding right at the top of the page.

Cheers

James