Screen Updating

[ercedwards]

I have a macro that clears all of the cells in a workbook before I repopulate them with new data.
The first step in the macro clears all of the Command Button captions. I then do an Application.Screenupdating=True

I then carry on to clear all other cells. As these are being cleared they appear as cleared on the screen.

The issue I have is that the Command Button captions don't appear as clear even though I cleared them first.

Since I repopulate everything immediately after, the original CB captions still show even though I have changed them and all of the correct data is in each cell.

Very strange. I've tried inserting WAIT, DoEvents and even re-selecting the workbook but neither helped.

Suggestions such as VBA code to refresh the Command Buttons?

Thanks kindly

 

[ercedwards]

I tried objX.object.visible=false and got the message object doesn't support this property or method

 

[Yongle]

Confusing I know, but the correct syntax for this is

objX.Visible = False

It will not solve your problem unfortunately