View Single Post
 
Old 01-18-2013, 06:55 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
I am not a VBA expert but your issue may be because you cannot unlock a cell before you unlock the Worksheet. You need to include code in your VBA to unlock the worksheet first before you unlock the cell. Then lock the worksheet again if you need to.
Hope this helps.
Good luck.
Tony
Reply With Quote