| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy sheet without Code
Hi All, Iam newbie to excel programming . I have a sheet with a command button and code associated with command button written in the sheet itself.(Ie not using any module).I want to make a copy of this sheet without this command button and and associated code, using VBA .IS this possible.Any help would be gr8 Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=384872 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet without Code
How important is it to you that the code be removed (this is a little tricky.
Possible but tricky for a newbie). You can just change the visible property of the button and everything is good to go. The button will be invisible and no one will know it is there. -- HTH... Jim Thomlinson "xcelion" wrote: Hi All, Iam newbie to excel programming . I have a sheet with a command button and code associated with command button written in the sheet itself.(Ie not using any module).I want to make a copy of this sheet without this command button and and associated code, using VBA .IS this possible.Any help would be gr8 Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=384872 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet without Code
This worked in Excel 2000
Sheets("sheet1").Cells().Copy _ Destination:=Sheets("sheet3").Range("A1") Left the command button on Sheet1 and didn't copy it to Sheet2. The only code in sheet2, will be stuff you put in after... use workbook references if you want to copy from one workbook to another. -- steveB Remove "AYN" from email to respond "xcelion" wrote in message ... Hi All, Iam newbie to excel programming . I have a sheet with a command button and code associated with command button written in the sheet itself.(Ie not using any module).I want to make a copy of this sheet without this command button and and associated code, using VBA .IS this possible.Any help would be gr8 Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=384872 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet without Code
Thanks Steve and Jim Thanks a lot for your suggestions.I will be very helpful for newbie like me. :) -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=384872 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy sheet without Code
You're very welcome!
keep on Exceling... -- steveB Remove "AYN" from email to respond "xcelion" wrote in message ... Thanks Steve and Jim Thanks a lot for your suggestions.I will be very helpful for newbie like me. :) -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=384872 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| what is the vb code to copy rows from one sheet to another? | Excel Discussion (Misc queries) | |||
| copy to sheet code question | Excel Programming | |||
| Copy Sheet w/o VBA code | Excel Programming | |||
| copy and paste from different sheets into one sheet using a VB code | Excel Programming | |||
Hybrid Mode
