Excel VBA running upon save

[chidmas]

Hi I am having an annoying problem where everytime I Save as a document certain macro runs (this is on the sheet rather than in the module) dependant on the selection for example I have a drop down menu where if you select no then the following macro will be run

Please Login or Register  to view this content.

So since the selection is No on saving the document it then means the userform is opened when I save it. Which I do not want to happen. Is there anyway of stopping this as its extremely annoying.

Thank you in advance.

[davesexcel]

Is there a code running when you save the workbook?

Please Login or Register  to view this content.

How is the ComboBox code being activated by savas?

[chidmas]

Well I do have a code which uses the saveas function to save the document but even when I use the normal saveas function in the menu the code just the macro I posted just runs.

I have assigned the code I posted onto the combobox and like the code says when it is clicked it executes the code and checks if No is selected.

Im unsure why you have posted that code

Any guidance would be great, thank you

[Izandol]

Do you have combobox linked to cells in ListFillRange or LinkedCell property?

[chidmas]

I have it linked with ListFillRange

[Izandol]

I think this is reason for code running. When workbook is saved it will recalculate. If this ListFillRange is dynamic or if there are formulas within the range, combobox may believe it has changed, and the event code will run. It is better to fill control using List property in code if possible.

[chidmas]

Thank you. Im sure im going to sound stupid but can you explain how you can do the above. Ive never herd of what you are refering to so any tips would be greatly appreciated.

[Izandol]

Of course - code will be like this:

Please Login or Register  to view this content.

You must decide when you need to populate list - it may be only when workbook is opened or perhaps each time worksheet is activated?