When a scrollbar is not a scrollbar

F

Flash in the Pan

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

ActiveSheet.OLEObjects.Add(ClassType:="Forms.ScrollBar.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 are:

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
 
T

Tom Ogilvy

Make the control toolbox visible.

go into design mode

select the control

click the properties button on the control toolbar and it should open the
properties window.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top