| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place Code question
Understood that. Thanks.
Regards. "zackb" wrote in message ... Create an additional button called "Export Worksheet" that copies the worksheet into a new workbook, deletes all the buttons and saves it to the name and location of the user's choice. If you have all related code in modules, none of it will follow the worksheet when it's copied out of the workbook.. Just to clarify, in case of any confusion (is usually more common with me), if there is code in the worksheet module and the entire worksheet (object) is copied, the code will follow; you must copy the cell *contents*, like a traditional copy/paste type of effort. -- Regards, Zack Barresse, aka firefytr |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where 2 place the code? (Worksheet Codes Vs. Modules) | Excel Discussion (Misc queries) | |||
| Is this the proper place to ask my question? | Excel Discussion (Misc queries) | |||
| Wherre best to place code | New Users to Excel | |||
| Place space in postal code | Excel Programming | |||
| Place code in a new workbook with a macro. | Excel Programming | |||
![Stuart[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
