how to hide scroll bar controll of a sheet when printed?

If it's an activeX control then -

Please Login or Register  to view this content.

If it's form control then I'm afraid I'm don't know.

Hope that helps

Dave H

Hi pejoi,

If you post an example I can probably sort this for you. Your form control scroll bars would need to be changed to Axtive X then use the command previous within a sub routine for when you want to hide/unhide.

Dave H

cubajaya.xlsm.example included.

Sorry pal,

Cant open your attachment. Use the go advanced button then manage attachments.

Dave H

In the meantime please see attached example sheet. The criteria for linking to a print event will need further disussion on how you want it to operate.

Cheers

Dave H

Ah pejoi,

That's quite a workbook. I think I have misunderstood your request.

Is it that

1. you don't want the scroll bars to appear in your printout
or
2. you want the scroll bars to disappear once the sheet is printed

Having seen your sheet I guess you want no1. Right click scroll bar=>Format control. Select properties tab then uncheck "Print object".

I have done this on the scrollbars for your sheet "khamis".

Hope that helps, but if not let me know.

Dave H