Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code module?
I'm sorry, but can someone please tell me where the "code module" is? I am
trying to set my worksheet to autoformat the height of each row, but it won't work for half of my rows, because I have some cell merged across multiple columns with text wrapping. So I found an answer on how to get things to work, but the response says to paste some text to the "worksheets code module". I have no idea where that is. If anyone can provide that answer, I would greatly appreciate it. Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code module?
Go back to excel.
Rightclick on the worksheet's tab that should have this behavior. Select view code and you'll see it. Kat wrote: I'm sorry, but can someone please tell me where the "code module" is? I am trying to set my worksheet to autoformat the height of each row, but it won't work for half of my rows, because I have some cell merged across multiple columns with text wrapping. So I found an answer on how to get things to work, but the response says to paste some text to the "worksheets code module". I have no idea where that is. If anyone can provide that answer, I would greatly appreciate it. Thank you! -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
code module?
"Kat" wrote:
.. the response says to paste some text to the "worksheets code module". If you right-click on the sheet tab choose "View Code", that brings you right into the exact place in the VBE where the "text" (presume this refers to the responder's subroutine) is supposed to be pasted in. Then you can get back to Excel by pressing Alt+Q, and test the sub out on that sheet. -- Max Singapore http://savefile.com/projects/236895 Downloads:22,000 Files:370 Subscribers:66 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code won't run from a module | Excel Discussion (Misc queries) | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
regular code module | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |