Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 01-25-2022, 08:33 AM
Logit Logit is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2007
Expert
 
Join Date: Jan 2017
Posts: 434
Logit will become famous soon enoughLogit will become famous soon enough
Default

Quote:
The only way I know how to do that is, open a new book then immediately save it as a xlsm file.
That is correct ... who first have to save the workbook as .XLSM



Quote:
I have this code embedded in a workbook. How do I view it when I'm in the book?
Right click any sheet tab, then select VIEW CODE.


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.
Reply With Quote
  #17  
Old 01-25-2022, 09:31 AM
Jimbir's Avatar
Jimbir Jimbir is offline Seleted Cell Highlighting Windows 7 64bit Seleted Cell Highlighting Office 2007
Advanced Beginner
Seleted Cell Highlighting
 
Join Date: Nov 2010
Posts: 33
Jimbir is on a distinguished road
Default

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.
Reply With Quote
  #18  
Old 01-25-2022, 11:28 AM
Logit Logit is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2007
Expert
 
Join Date: Jan 2017
Posts: 434
Logit will become famous soon enoughLogit will become famous soon enough
Default

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.
Reply With Quote
  #19  
Old 01-25-2022, 01:10 PM
Jimbir's Avatar
Jimbir Jimbir is offline Seleted Cell Highlighting Windows 7 64bit Seleted Cell Highlighting Office 2007
Advanced Beginner
Seleted Cell Highlighting
 
Join Date: Nov 2010
Posts: 33
Jimbir is on a distinguished road
Default

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.
Reply With Quote
  #20  
Old 01-25-2022, 02:03 PM
Logit Logit is offline Seleted Cell Highlighting Windows 10 Seleted Cell Highlighting Office 2007
Expert
 
Join Date: Jan 2017
Posts: 434
Logit will become famous soon enoughLogit will become famous soon enough
Default

Go to ThisWorkbook module and see if you need to scroll down or up .... left or right.

Perhaps the code is simply "off screen".
Reply With Quote
Reply

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
Seleted Cell Highlighting 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
Seleted Cell Highlighting highlighting Donnathompson Word 4 08-07-2011 05:21 PM
Cell highlighting Issue jasonk916 Excel 0 12-07-2009 07:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft