Paste Options Menu Acting Up...

nihilismo

New Member
Joined
Mar 13, 2018
Messages
1
Hello! Been a long-time lurker but this forum is great am curious enough if anyone's ever seen the Paste Options button behave so oddly and disappearing?

Excel Options menu's options are set up correctly and it does indeed still appear at the expected location). You'll notice in the uploaded .gif that even when I was able to get my cursor directly over where it'll pop up and got the dropdown to briefly appear in some of the frames, it vanishes right away. (I guesstimate that it's there for all of, ~250ms maybe.) 'Ol Reliable Alt+Shift+F10 won't do anything, although the full Paste Special window can still be had with Ctrl+Alt+v. I've confirmed that my cat isn't sleeping on a wireless keyboard in another room or anything like that. This one's just a head-scratcher.

Windows clipboard was thoruoughly cleared a handful of times and the Esc & Print Screen keys were used liberally but didn't help. I don't have any new installations or updates or anything wild that I am aware. (Confession: I'm still using Office 2007 that I legitimately purchased many many moons ago and I am ride or die with it since I'm a cheapskate, am fairly careful playing around with unfamiliar macros and the sort, and lastly, I'd rather use Lotus purely out of spite before succumbing to an Office365 subscription. And... none of this is relevant to the topic anymore. Sorry. Thanks for reading!)

tl;dr - Anybody else ever had their Paste Options pop-up do this? It's more of a mild annoyance. Maybe it'll go away as randomly as it started, who knows? I'll boot in safe mode and play around with that later.
 

Attachments

  • XL_paste_options_button_disappearing_act.gif
    XL_paste_options_button_disappearing_act.gif
    146.1 KB · Views: 13

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Welcome to the MrExcel board!

Is is doing this in all worksheets and all workbooks or just one/limited number?

In the gif as the option button disappears, it seems like a range one column wider and one row deeper is momentarily selected. Makes me wonder if there isn't some event-driven macro triggered by the paste action. Are you sure there is no Worksheet_Change or Workbook_SheetChange event codes in the workbook?
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,908
Messages
6,175,304
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top