Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How do I copy worksheets with drop-down menus intact?

Yes, validation drop downs. I want to copy the worksheet to another
workbook. I'll try UR solution. Much thanks.

"Bob Umlas" wrote:

How are you copying the sheet? And dropdown menus are not part of a
worksheet anyway, they're part of the menuing system (commandbars). So,
assuming you're referring to data validation dropdowns or combobox
dropdowns, you need to copy the sheet with Edit/Move or copy sheet (or
ctrl-drag the sheet tab).
Copying cells won't do it.

"ErnDog" wrote in message
...
When I attempt to copy a worksheet with drop-down menus, the worksheet

copies
fine, but the drop-down menus to not copy at all.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I copy a group of worksheets with named ranges in Excel 200 sc Excel Worksheet Functions 2 September 26th 06 12:16 AM
Navigating between worksheets using a drop down menu ncdogteam Excel Worksheet Functions 4 July 13th 06 11:40 PM
Data Validation drop down for multiple worksheets singla Excel Worksheet Functions 0 December 14th 05 05:56 PM
Drop Down Menu's abfabrob Excel Discussion (Misc queries) 4 February 4th 05 02:19 PM
Drop down menus Please help Excel Discussion (Misc queries) 1 January 29th 05 07:05 PM


All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"