ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   When a scrollbar is not a scrollbar (https://www.excelbanter.com/excel-programming/360001-when-scrollbar-not-scrollbar.html)

Flash in the Pan

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



All times are GMT +1. The time now is 01:50 PM.

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