PDA

View Full Version : [SOLVED] Format Shape menu appears after a printpreview.



paulked
09-16-2017, 05:20 AM
Hi all.

Also posted in MrExcel here: https://www.mrexcel.com/forum/excel-questions/822498-format-shape-menu-appearing-during-print-preview.html

When I run a macro with printpreview everything looks ok until I return to the worksheet and find that the Format Shape menu has appeared on the right hand side.

Any ideas?

Kenneth Hobs
09-16-2017, 07:33 AM
Works fine for me.

Sheet1.PrintPreview False

You must have something else going on. You can attach a file that duplicates the problem if you like. Click the Go Advanced button in lower right of reply and then the Manage Attachments hyperlink below the reply box, Choose File, browse and Upload.

paulked
09-16-2017, 08:15 AM
Thanks for reply. I was just about to post that it has stopped happening!

The only changes I've made to the workbook is added a few more shapes... And it's gone!

sgsmith
11-10-2022, 03:08 PM
I know that this is a super old post, but there isn't much out there on this topic even now. I used the following and it works every time for me.


Application.CommandBars("FormatObject").Visible = FalseI just put that directly after the print preview. Hope that helps someone.