Remove vertical scrollbar from spreadsheet in VBA code?

P

Paul

I have a spreadsheet that is placed on an Outlook custom form and I would like to add/remove the vertical scrollbar in the VBA code. Can anyone provide any syntax on how to do this? Thanks in advance.
 
V

Vasant Nanavati

I don't know if this will work with an Outlook form but the standard syntax
is:

ActiveWindow.DisplayVerticalScrollBar = False

--

Vasant

Paul said:
I have a spreadsheet that is placed on an Outlook custom form and I would
Click to expand...
like to add/remove the vertical scrollbar in the VBA code. Can anyone
provide any syntax on how to do this? Thanks in advance.
 
T

Tom Ogilvy

ActiveWindow.DisplayVerticalScrollBar = False

--
Regards,
Tom Ogilvy

Paul said:
I have a spreadsheet that is placed on an Outlook custom form and I would
Click to expand...
like to add/remove the vertical scrollbar in the VBA code. Can anyone
provide any syntax on how to do this? Thanks in advance.
 
Top