Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have written a series of macros and functions in Word that transform a very
large text file into a delimited format that can be imported and formatted in Excel. Once that data has been imported and formatted appropriately in Excel, I want to copy a few modules of code into that spreadsheet so that the user may run them when the macros are done. Thanks to Chip Pearson, I am able to copy a full module, but I've noticed that the module is visible from the "Macros" dialog box. I don't want the user to try to run the macros meant for Excel from within Word, but I don't know how to "hide" the macros so that they can't be run. My alternative now is to run a function that generates a Long variable containing the text of the Excel macros, but I want to know if there is an easier way. Please let me know if clarification is needed, and thanks in advance. Pflugs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel crashes when copying to Word?? | Excel Discussion (Misc queries) | |||
Copying comments from Word to Excel | Excel Discussion (Misc queries) | |||
Excel Word copying info from Excel to Word without gridlines / bor | Excel Discussion (Misc queries) | |||
copying word tables into excel | Excel Worksheet Functions | |||
copying data from word to excel | Excel Programming |