Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,080
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vertical scrollbar in Excel a0xbjzz Excel Discussion (Misc queries) 1 July 16th 08 08:29 PM
Split, the vertical scrollbar is half way down the spreedsheet Kathy Excel Discussion (Misc queries) 2 April 20th 08 02:11 PM
Scrollbar, vertical jrich15322 Excel Discussion (Misc queries) 6 October 5th 06 12:53 PM
How do I make my spreadsheet so part of it has it's own scrollbar SarahQ Excel Discussion (Misc queries) 1 September 5th 06 08:41 AM
Lower Boundary of Vertical Scrollbar noplasma Excel Discussion (Misc queries) 0 January 5th 06 05:24 PM


All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"