Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to copy excel worksheets between workbooks without subroutines.

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Hi!
I want to copy Excel sheet where a button is placed and I don't want to copy this button's subroutine. How to do it?

How do remove the button from the new worksheet?
I've tried like this:

Worksheets(1).CommandButton1.Delete but it doesn't work.

but this works

Worksheets(1).CommandButton1.Visisble=False

Why?

Please help.

Jacek
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top