Command button text enlarges when print preview is exited

Hi All,

I have created a protected staff scheduling worksheet in Excel 2010 with over twenty command buttons and one toggle button, three of which are used to print different sections of the schedule.

I can select one of the print command buttons, change print settings and print normally from the print preview and the worksheet will return to its normal state after selecting print. However, if I choose to exit the print preview without printing, via the close print preview button, upon returning to the work sheet all the text on every command button and the toggle button has been enlarged.

All three print buttons use similar code:

Please Login or Register  to view this content.

If I click the toggle button after the text has been enlarged, the text in some of the command buttons reverts back to normal but others remain in an enlarged text state. The only way all buttons appear to revert back to normal is if I select one of the print buttons again and then print instead of exiting the print preview.

It is the command button text only not the button size that is effected. Does anyone have any idea what is causing this issue?

Many thanks,

If you used ActiveX control buttons (instead of forms control buttons) that would explain the problem. ActiveX controls exhibit such odd and unpredictable behavior that I stopped using them years ago. If not ActiveX, then I don't know why that issue would occur.

I have decided to use form controls as I believe the issue to be in the unstable nature of ActiveX. This has opened up another issue that I will start a new thread for!

Ron, thanks again for your input.

Regards,

Hi L plates

Take a look at this Link for a possible solution to your Button Issue. If you're interested in pursuing this, I'll be glad to help.

Look in particular at around Post #207.

http://www.excelforum.com/excel-prog...ol-button.html

Hi jaslake,

Thank you for your kind offer of assistance. I tried pasting the code in post 207 to my workbook and can see how refreshing each sheet may solve the issue but could not adapt it to my print control button. When I select any print button, the button code is directed straight to the refresh code and the print preview is no longer being displayed and no printout occurs.

I have noticed that when the print preview does show with my original print code only, the preview image is scaled down to about 40% zoom but the button text remains scaled at 60% zoom. When I exit the preview without printing, the image is scaled back to the original 60% zoom state but the text gets scaled up with it. I tested this theory by zooming out to 40%, select print and then exit and found that when I zoomed back in to 60% the button text was its correct size. I also discovered that it only affects two of the print buttons - "PRINT SCHEDULE" & "PRINT EVENING SALES". These two buttons both hide rows when selected. The other print button does not.

I'm guessing that I could add some lines of code to the two affected print buttons that zoom out to 40% before print preview and revert back to 60% zoom afterwards. A bit clunky perhaps and not sure if I can zoom with VBA yet. I have attached the workbook. Lots of code for other buttons that needs to be worked with yet by me but you will be able to see the print issue straight away.

Many thanks,

Hi L plates

The Code I referenced does not solve your issue.

You may wish to take a look at this link as it appears to describe your issue

http://support.microsoft.com/kb/2598144

Apparently Excel 2010 has a problem.

Hi jaslake,

Thank you for the suggestion. As my workbook is intended for use on a workplace network any fix requests for excel 2010 would be ignored by my IT department. As I get back from holiday I also find that 2010 has been replaced by 2013! The bug still exists and I may just have to live with it for the moment while I work on other aspects of the workbook.

I may get time to revisit this soon.

Many thanks,