Paul, Thanks for the swift response, found a simple workaround, user error ;-))
On Apr 15, 4:57 pm, Paul Schreiner <schreiner_p...@att.net> wrote: > First of all, we'd need to see the code to give an accurate assessment. > There are several techniques that can be used to change the cell height. > The technique you selected could be the culprit. > > Second... you say that "all the other cells on the worksheet are locked > apart from this one and the sheet protected"... > I take it that you are allowing the formatting of cells/rows/columns > when you protect the sheet? > Because you cannot change the height of individual cells, you must > change the height of the entire row, including the locked cells. > > again, I think it would be much easier if we could see the code... > > Paul > > ________________________________ > From: steviewood <steven.w...@ctcplc.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Wednesday, April 15, 2009 10:06:58 AM > Subject: $$Excel-Macros$$ Locking of cells after macro has run > > Hello, > > I have a macro to reformat the height of a group of merged cells which > makes up the "comments section". All the others cells on the worksheet > are locked apart from this one and the sheet protected. However when > the macro runs to re-format the box height, the cell becomes locked > disabling the user from making any amendments after the original > entry. > > Any clues anyone please?? > > Thanks. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---