×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel Validation Drop Down Box Clears / Disappears when Saving . Could this be VB coding causing it

Excel Validation Drop Down Box Clears / Disappears when Saving . Could this be VB coding causing it

Excel Validation Drop Down Box Clears / Disappears when Saving . Could this be VB coding causing it

(OP)
Hi

Can anyone help. I have an issue with my excel sheet that loses the drop down data validation boxes when saving. I'm not sure what is causing it but wondered if it could be VB code or I could write some VB to stop it happening?

Many Thanks

RE: Excel Validation Drop Down Box Clears / Disappears when Saving . Could this be VB coding causing it

What excel version? Do you have any code in the workbook? Does the cell still has data validation set when you open the file?
Older versions had problem with data validation dropdown button display for workbooks with linked range images (as camera tool). At least in 2016 this issue was fixed in one of updates. The workaround was:
1) add forms combobox anywhere in the worksheet,
2) right-click it and add whole worksheet as data source,
and data validation arrows appear and work.

If it is not your case and you have DV saved, please upload workbook with disappearing DV after removing sensitive data.

combo

RE: Excel Validation Drop Down Box Clears / Disappears when Saving . Could this be VB coding causing it

(OP)
Hi thanks for the response

I have excel version 2013. I do have code in the work book but nothing that activates when opening / closing the workbook
I'll try the combobox solution and let you know

thanks again

RE: Excel Validation Drop Down Box Clears / Disappears when Saving . Could this be VB coding causing it

(OP)
Hello

A quick update to say thanks and it seems that my code was saving the workbook as a standard excel file.

I have now adjusted my code to save as a Macro Enabled Workbook

This seems to have worked

Many Thanks for your help

RE: Excel Validation Drop Down Box Clears / Disappears when Saving . Could this be VB coding causing it

To show appreciation for the help, click on Great Post! link in the helpful post(s). That marks the post(s) with a star, and let others know it was beneficial

Welcome to Tek-Tips smile


---- Andy

There is a great need for a sarcasm font.

RE: Excel Validation Drop Down Box Clears / Disappears when Saving . Could this be VB coding causing it

(OP)
Andrzejek

Thanks for your advice, great post clicked

DylaBrion

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close