Drop down menu font is too small. Code worked for some time. Now it does not

[KK1234]

Hi,
I am using the following code to zoom cells which have drop down menu, as the font is too small and can not be seen.
Initially it is working fine, but all of a sudden it has stopped working.
I also have many change events in one sheet as well

Any help with this or a better code which is applied to all cells in all sheets having drop down menu and can be stored in Thisworkbook or like.

Please Login or Register  to view this content.

[JosephP]

does it work if you restart excel?

[KK1234]

Hi,
Yes it works when excel is restarted. I have just tried now.
What could be the reason?
Will this happen again while sheet is in use?
Thanks again
Regards

[JosephP]

I suspect you have other code that disables events and fails to reset them for some reason

[KK1234]

Hi,
You are right.
I will investigate and will get back to you. I have three change events in one sheet. And I have 15 sheets. It is a maze.
I have been able to combine two.
I also suspect that one of these change events is causing this issue.
I will try and combine all of them and then will get back to you to resolve this issue.
Thanks again
Regards

[KK1234]

Hi
Sorry to get back to you late.
It finally worked .
I had so many codes that it was interfering.
Finally it is resolved.
Your code works very well.
Thanks again Mate
Regards

[bsp9493]

Hi... this code does exactly what I need it to do, however, here is the problem. (note: I am testing with copies of the exact same workbook in my examples, as well as a blank workbook with a simple list of 5 items in data validation)

Excel for MAC 16.22 - this works PERFECTLY, in my test example, and ANY other workbook I use it in, it works Great!

However, when I try to open/use this workbook, or code on a PC based Excel product - it does NOT work!
I have tried in the following scenarios (with NO success)
MS Office Standard 2013 - Windows 8.1 Pro
MS Office (Office 365 - newest version) - Windows 7 Professional
and
MS Office (Office 365 - newest version) - Windows 10 (newest version)


- am I missing a library on ALL of the windows machines?
- is there another way to do this exact same thing? - I have tried other similar code that zooms in on the data-validation box, but none seem to work on the windows machines.
- is there a security setting I am missing?

the workbooks are saved as macro enabled, and accepted as such when opening.

Your help would be MUCH appreciated!

Thanx

d
The code does NOT work on any of the Windows base implementations work