HELP - VBA

[dipsy]

Hello! I have a macro that creates a pivot table and a
macro that displays only selected items from the Pivot
Table. When I run this macro - the form buttons on the
screen disappear.

Thanks.

 

[Dave Peterson]

I don't have a real good guess.

Are you sure the form controls (placed on the worksheet????) disappeared? Maybe
they're still there (can you kind of click on the last seen location?).

I'm thinking that maybe it's a display problem--not really an excel problem.

If you save, close excel and reopen your workbook are they back?

Maybe you could add some code like:

with activesheet.buttons("button 1")
.visible = false
.visible = true
end with

To see if they're gone or just hiding.