Unrelated macro prevents typing in cells, until switching to another tab and back again

Hello,

Fairly new to Excel/VBA stuff, so forgive me if I've made a stupid mistake somewhere.

I have a spreadsheet formatted like a calendar, and have some simple ActiveX buttons on the right.

When one of these buttons are clicked, it runs the following macro on the currently selected cell:

Please Login or Register  to view this content.

There are many macro's like this, running from A through to K (ColorCodeA, ColorCodeB, etc.)

However, once I have clicked this, I can no longer enter any data in to any cells on that sheet until I have switched to another tab, and back to the original one.

It doesn't matter if the cell/sheet/workbook has any protection settings active or not, and I don't have to do anything else except switch between tabs.

I'm not sure what could be causing this. I have some other macro's in the workbook, spread across three module's, but this still happens even if they haven't been run since closing and re-opening the workbook.

I would appreciate any assistance in trying to find the source of this annoying problem.

Regards

Craig

could try

Application.ScreenUpdating = False
Then execute all your code with formatting
.....
....
Final step
Application.ScreenUpdating = True

Originally Posted by ThirtyTwo

could try

Application.ScreenUpdating = False
Then execute all your code with formatting
.....
....
Final step
Application.ScreenUpdating = True

Thanks for the reply.

I tried the code, but still having the same issue..

Regards

how about a final step of the routine to select or activate a cell on the sheet

Please Login or Register  to view this content.

Tried this code too, but still not working.

I still have to switch to another tab and then back again in order to enter data..

Regards