Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default When a scrollbar is not a scrollbar

I used the following code to create a scrollbar on my worksheet:

ActiveSheet.OLEObjects.Add(ClassType:="Forms.Scrol lBar.1",
Link:=False, _
DisplayAsIcon:=False, Left:=CurrentLeft, Top:=CurrentTop,
Width:=460, _
Height:=13.5).Select

After running it, a scrollbar was created on my worksheet
But when I go into design mode and then right click on this scrollbar
to change properties (like I've always done in the past), properties is
not there in the pop up menu.
The selctions I do get a

Cut
Copy
Paste
------------
Scrollbar Object
Show Picture Toolbar
------------
Grouping
Order
------------
Assign Macro...(disabled)
Format Object...

Whereas, I get the following menu choices when I right click on a
manually created scrollbar:

Cut
Copy
Paste
------------
Properties
View Code
------------
Scrolbar Object
------------
Grouping
Order
------------
Format Order...

Any ideas on what's wrong

Thanks

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
Scrollbar Help kay Charts and Charting in Excel 1 October 29th 08 05:35 PM
Scrollbar help [email protected] Excel Discussion (Misc queries) 1 January 19th 07 10:48 PM
Scrollbar dstiefe Excel Programming 3 August 12th 05 08:12 PM
scrollbar reslut makes another scrollbar to show Patrik Excel Discussion (Misc queries) 0 April 18th 05 03:11 PM
Scrollbar junx13[_11_] Excel Programming 0 September 20th 04 08:03 AM


All times are GMT +1. The time now is 10:43 PM.

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"