Posted to microsoft.public.excel.programming

external usenet poster

Posts: 269

Don't copy buttons

I'm using VBA to copy a range from a worksheet in one workbook to a
worksheet in another workbook. The range I'm copying from has buttons
that I don't want to copy. Can I copy the range without copying the
buttons? Alternately, can I delete only the buttons in the copied
range when finished copying (to prevent deleting buttons already on the
destination sheet)? The buttons on both sheets were created with the
Forms menu. ExcelXP (2002). I cannot control the properties of the
buttons in the source file. TIA, James

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What keyboard has buttons of cut, copy and paste on it?	rcnwrc	Excel Discussion (Misc queries)	1	January 12th 06 07:02 PM
Copy buttons by rows	Optitron	New Users to Excel	21	August 30th 05 08:56 PM
How to copy a workbook so the buttons run the macros?	-	Excel Discussion (Misc queries)	4	May 15th 05 11:24 PM
copy sheet with buttons	hans[_4_]	Excel Programming	0	March 14th 05 02:07 PM
Do not copy buttons or macros	Gbiwan	Excel Programming	3	February 27th 04 03:40 AM

All times are GMT +1. The time now is 02:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us