macro needed to hide form controls

Hi champs,

I have a xls file with many form controls (Scroll bars) and charts and data.

For the print i need to save save the file as pdf without any form elements.

Please help me in creating macro to hide all the form controls.

I tried with below code but it hides the CHARTS too.

Dim sh As Shape
For Each sh In ActiveSheet.Shapes
sh.Visible = False
Next

So please help if any specific macro is available to hide only form elements.


Thanks in advance.

try this

Please Login or Register  to view this content.