Hello, I am having a small problem. I used to have a macro calle
"VerifyJobs" on my sheet which I deleted but when I protect this shee
(Only one column is actually locked) i am unable to click on a cel
without it trying to call this macro and getting an error, i am no
even clicking on a cell in the locked range. Does anyone know why thi
is happening?

Thanks for any help

Joh

--
johncassel
-----------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...fo&userid=2501
View this thread: http://www.excelforum.com/showthread.php?threadid=39809

One possibility: Sheets have events one of which is SheetChange.
Perhaps the sheet is responding to one of these events and is calling
VerifyJobs. Open up the VB Editor and select the sheet to view any code
it may contain.

unfortunately I have already thought of that and there is no code on the
sheet. thanks for your reply though


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=398099