Hi there
I have one specific sheet that I need to retain the Align Central format in even if information is cut from.
At the moment they are aligned centrally, but when I cut information it reverts to aligning left.
Does anyone have any idea for how to do this in one sheet only?
Thanks in advance for your help.
Steve
Cross posted - http://www.mrexcel.com/forum/excel-q...ml#post3641581
Assuming that we are taliking about column C, this one will do what you want.
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Instead of using cut and paste, use copy and paste then delete the contents of the source cell.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or you could take Fotis's recorded macro and edit it down.
Please Login or Register to view this content.
Hi Tim and Fotis, thanks for the solutions, very much appreciated. Apologies for being unclear, but what I'm hoping to be able to do is set that specific sheet up so that everything is aligned centrally when it's opened and there is no possibility of a user taking an action that will allow that to be changed, but they can still input, delete, cut, copy and paste information in and out of the cell.
Thanks for your continued help
Steve
If you "cut" a cell, then it will remove not only the contents (value or formula) but also the formatting of the cell, Conditional Formatting and Data Validation. Equally, if you paste a cut cell somewhere else, it will take all the original cell's properties with it.
I'm not sure how you can maintain the integrity of the worksheet if people can cut and paste as they wish.
If you want to copy the cell, you should use Copy and Paste, then Delete, rather than Cut. If you want to paste a cell, use Paste Values or Formula.
If you want a VBA solution, you could have, say, a Selection Change event which centres the contents of the cell when it is selected.
Regards, TMSPlease Login or Register to view this content.
Perhaps using a Worksheet event. Something like this...
Please Login or Register to view this content.
Sorry, I enjoy interfering, sorry (again), tinkering with Fotis's code.
Could be:
Please Login or Register to view this content.
You could remove the commented lines if you don't want/need to apply that formatting.
Regards, TMS
Last edited by TMS; 11-22-2013 at 07:03 AM. Reason: Slight modification to code
I enjoy to see you to do this Trevor!Originally Posted by TMShucks
Great, thanks for the combined effort guys, really appreciate your help
You are welcome and thanks for the feedback & rep.
Ditto. You're welcome. Thanks for the rep.
Just out of interest, what did you decide to do in the end? TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks