scrollbar hide

[kalpesh]

Hello

i create a macro to hide scrollbar vetical & horizontal when sheet1 i
active but problem is all other sheets scrollbar is hid
why

 

[GS]

kalpesh explained :

Hello,

i create a macro to hide scrollbar vetical & horizontal when sheet1 is
active but problem is all other sheets scrollbar is hide
why

The ScrollBar belongs to the Window, NOT the worksheet.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Gord Dibben]

Scrollbars is a Windows setting, not a sheet setting.

Add it to your sheetactivate and deactivate events.


Gord

 

[Gord Dibben]

That should read Window setting, not Windows setting.

All sheets are in the same Window.


Gord