Unlocking cells with VB code in excel 2003

		Microsoft Office Forums > Microsoft Excel > Excel
Unlocking cells with VB code in excel 2003

FAQ

Thread Tools

Display Modes

01-18-2013, 06:55 AM

OTPM

Windows 7 32bit Unlocking cells with VB code in excel 2003

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only	mag	Excel	0	10-28-2012 08:04 PM
VBA Code to auto resize cells when text entered	OTPM	Excel Programming	0	09-18-2011 04:21 AM
VBA code to update record in Access 2003 using Userform in Excel	primmer3001	Excel Programming	0	08-29-2011 04:25 PM
Unlocking documents	deekins	Word	2	05-20-2009 12:07 PM
Automatically entering/fill data in cells in Excel 2003	dipdog	Excel	0	08-17-2006 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:07 PM.