#16
|
|||
|
|||
Quote:
Quote:
The suggested macro found in How to highlight active cell or selection in Excel? should be pasted in the ThisWorkbook module. Right click any sheet tab and select VIEW CODE. Then, on the left side, double-click the module name ThisWorkbook. Now, paste the macro code in the large white colored window on the right. Save the workbook as .XLSM and close it. Re-open the workbook and click on any cell. |
#17
|
||||
|
||||
Thanks for the reply.
I already have the code embedded in a xlsm workbook and it's working. No matter what I click or right click on, I don't see the code. |
#18
|
|||
|
|||
If you already have the code in the workbook ... and the code is working as it should ... where did you paste the code ?
You are listed as a "Advanced Beginner" in this forum ... you cannot say you don't see any code. |
#19
|
||||
|
||||
My listing is out running my ability.
I was in a xlsx workbook and followed the instructions in this link. Highlight active cell or selection with VBA code When I tried to save the book, I got a message telling me I could only save it as a macro enabled book so I saved it as a xlsm. When I opened that book. the macro worked fine. My problem is, when I hit ALT>11' an empty code window show up. When I hit CTRL>R, the project explorer will show up. hitting anything in it doesn't bring up anything in the code window. |
#20
|
|||
|
|||
Go to ThisWorkbook module and see if you need to scroll down or up .... left or right.
Perhaps the code is simply "off screen". |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter | PrincessApril | Excel | 6 | 12-06-2019 02:38 PM |
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow | FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
Word tables: prevent word from highlighting whole cell when I highlight text | skylark53 | Word | 2 | 08-04-2015 08:12 AM |
highlighting | Donnathompson | Word | 4 | 08-07-2011 05:21 PM |
Cell highlighting Issue | jasonk916 | Excel | 0 | 12-07-2009 07:05 AM |