ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Save As problem (https://www.excelbanter.com/excel-programming/391884-save-problem.html)

cshelton17

Save As problem
 
I have a workbook that has some code behind in a few sheets. When a user
chooses to save the file as "Save As" to name it different, one of the
dropdown box's change code runs. This is causing an issue because this code
changes some other values that shouldn't change when you are trying to save.
I don't know why it is running this code.Thanks in advance for any help.

Dave Peterson

Save As problem
 
Do you have a .linkedcell for that combobox on that same sheet? How about the
..listfillrange?

Moving them to a different sheet may help--or doing the equivalent in code would
help.

cshelton17 wrote:

I have a workbook that has some code behind in a few sheets. When a user
chooses to save the file as "Save As" to name it different, one of the
dropdown box's change code runs. This is causing an issue because this code
changes some other values that shouldn't change when you are trying to save.
I don't know why it is running this code.Thanks in advance for any help.


--

Dave Peterson


All times are GMT +1. The time now is 11:34 PM.

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