Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrollbar Help | Charts and Charting in Excel | |||
Scrollbar help | Excel Discussion (Misc queries) | |||
Scrollbar | Excel Programming | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
Scrollbar | Excel Programming |