ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Remove vertical scrollbar from spreadsheet in VBA code? (https://www.excelbanter.com/excel-programming/290625-remove-vertical-scrollbar-spreadsheet-vba-code.html)

Paul

Remove vertical scrollbar from spreadsheet in VBA code?
 
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.

Vasant Nanavati

Remove vertical scrollbar from spreadsheet in VBA code?
 
I don't know if this will work with an Outlook form but the standard syntax
is:

ActiveWindow.DisplayVerticalScrollBar = False

--

Vasant

"Paul" wrote in message
...
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.



Tom Ogilvy

Remove vertical scrollbar from spreadsheet in VBA code?
 
ActiveWindow.DisplayVerticalScrollBar = False

--
Regards,
Tom Ogilvy

Paul wrote in message
...
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.




All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com