Screen Refresh

[Giordano Bruno]

On one worksheet I have a group of buttons (not actually grouped, but just adjacent). When I click one of the buttons is unhides another worksheet and hides the first worksheet. The buttons show as an image on the second worksheet and the real buttons on the second worksheet are not visible. If I change worksheets and then back again the grouped button image goes and the correct buttons show.
If anyone has a solution to this problem I would be very grateful.

 

[James006]

Hello,

What kind of Buttons are you dealing ...?

Most probably with ActiveX ones ... the problem would disappear ...

 

[Giordano Bruno]

Hi James. Thanks for the reply. They're just shapes to which I've attached some code. I have found a way to make the problem go away. The code not only changed worksheets, but after the change had been made, also added the line
ActiveSheet.PageSetup.PrintArea = "$A$7:$G$" & LastRow
I have removed this line and added it to a print button on the target worksheet. I would prefer to keep the line of code with the change sheets code, but it creates this problem when included with the original code.

 

[James006]

Glad you could fix your problem