ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   drop-down menu in an excel spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/145299-drop-down-menu-excel-spreadsheet.html)

DC

drop-down menu in an excel spreadsheet
 
I created a drop-down menu in an excel spreadsheet, but when I attach the
spreadsheet to an e-mail and send to a recipient, the drop-down menus
dissappear in the spreadsheet

Kath

drop-down menu in an excel spreadsheet
 
Are you both using the same version of Excel?
Is the drop down menu referencing a worksheet that is not being sent?

K

"dc" wrote:

I created a drop-down menu in an excel spreadsheet, but when I attach the
spreadsheet to an e-mail and send to a recipient, the drop-down menus
dissappear in the spreadsheet


DP7

drop-down menu in an excel spreadsheet
 
What was the source for your validation list? If your list was from another
spread sheet that could be why your list disappears when you e-mail it to
someone else. Where is the data for your list stored?

"dc" wrote:

I created a drop-down menu in an excel spreadsheet, but when I attach the
spreadsheet to an e-mail and send to a recipient, the drop-down menus
dissappear in the spreadsheet


FSt1

drop-down menu in an excel spreadsheet
 
hi,
if I understand you, you are talking about a custom menu item.
Custom menus only apply to the pc that is customized. They do not apply to
files.
sorry,
Regards
FSt1

"dc" wrote:

I created a drop-down menu in an excel spreadsheet, but when I attach the
spreadsheet to an e-mail and send to a recipient, the drop-down menus
dissappear in the spreadsheet



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com