| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel cmd button
Can anyone help? I have a xls file OfficeXP. I have
command buttons on it with vba code behind the buttons. In one file that I have when I use the copy sheet function it copies the button and the code behind the button to a new sheet in the same file. In the other file when a sheet is copied the button is copied but it does not have any coding behind it. Why would these behave differently? I want the code copied with the sheet and button. Thanks for any help.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel cmd button
is the code in the button or is the button calling a
private sub? -----Original Message----- Can anyone help? I have a xls file OfficeXP. I have command buttons on it with vba code behind the buttons. In one file that I have when I use the copy sheet function it copies the button and the code behind the button to a new sheet in the same file. In the other file when a sheet is copied the button is copied but it does not have any coding behind it. Why would these behave differently? I want the code copied with the sheet and button. Thanks for any help.. . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel cmd button
If you copy the worksheet, the code contained in that sheet module should be
copied as well. Your experience seems to be atypical. -- Regards, Tom Ogilvy "Terry" wrote in message ... Can anyone help? I have a xls file OfficeXP. I have command buttons on it with vba code behind the buttons. In one file that I have when I use the copy sheet function it copies the button and the code behind the button to a new sheet in the same file. In the other file when a sheet is copied the button is copied but it does not have any coding behind it. Why would these behave differently? I want the code copied with the sheet and button. Thanks for any help.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Undo button and redo button quit | Excel Discussion (Misc queries) | |||
| Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
| insert row above button (retrieve position of button) | Excel Discussion (Misc queries) | |||
| How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
| Delete a custom button by holding down the ALT key and dragging the button off the toolbar | Excel Programming | |||
Linear Mode
