Copy and paste locks up cell

data808

Active Member
Joined
Dec 3, 2010
Messages
358
Office Version
  1. 2019
Platform
  1. Windows
When I copy this font (below) from a web site, it locks up the cell and I can no longer edit or even select the cell anymore:

HONOLULU DIVISION

I have a macro running that does an auto date and its also password protected so in order for the macro to work I had the macro unlock the spread sheet then do the auto date and then lock it back up. I'm thinking this is the problem but is there a way I can copy and paste this without getting rid of the macro? I do a lot of copying and pasting from this site but am not able to because it locks up the cell and the cell can no longer be selected. The only way out is to click the undo button.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
By the way, that HONOLULU DIVISION from my other post and this one too, is from the actually site and if I were to copy and paste it from here into my spreadsheet, it will lock up the cell.

It must be a compatibility issue with the font style and microsoft office excel.

HONOLULU DIVISION
 
Upvote 0

Forum statistics

Threads
1,224,600
Messages
6,179,834
Members
452,947
Latest member
Gerry_F

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