|
|
|
|
#1
04-05-2021, 08:49 PM
|
|||
|
|||
you shouldnt be running anything, if you put the code in the Worksheet (Pink) rather than a normal module it should trigger when the sheet changes.
You need to make sure the worksheet is selected in the left drop down (yelllow) and change on the right (green) I dont think the attached will cover everything you need - for example an undo or limiting the indent to only 10 for a > (what happens if you type >>?) 
|
|
#2
04-05-2021, 09:41 PM
|
||||
|
||||
|
Ah okay. There are codes in the Module and Workbook in the first file that I copied. I deleted them and now it is perfect. I changed the InsertIndent 10 to 1. Thank you Purfleet.
Another please. When the tables are loaded to a power query, the indents are deleted in the process. What I do to return the indents in the resulting query table is by Find ">", Replace "five spaces >". Can the code above be changed to find the ">" then apply the indents?
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date | trevorc | Excel Programming | 1 | 03-04-2021 02:39 PM |
 Formula to format "I" column based on if "F" column row is not blank
|
ravl13 | Excel | 3 | 08-22-2017 12:26 PM |
| Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
| the character "v" when typed acts like ctrl-v. | jim redfield | Word | 1 | 09-22-2012 05:19 AM |
| Why the "decrease indent" doesn't affect the selected text to move???? | Jamal NUMAN | Word | 0 | 07-12-2011 04:10 PM |
Windows 10 
Office 2019
Hybrid Mode