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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
