Format Shape menu appears after a printpreview.

[paulked]

Hi all.

Also posted in MrExcel here: https://www.mrexcel.com/forum/excel-...t-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]

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]

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]

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 = False

I just put that directly after the print preview. Hope that helps someone.