Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is correct syntax for a CommandButton?
Hi
I can't seem to understand the method to change a .Shadow property of a series of CommandButtons on different sheets. I am trying by using a For...Next loop, cycling through the sheets and for each CommandButton3 on the sheet - set or unset the button shadow depending on other factors. I have tried all sorts, but as usual, obviously not the correct way. i.e. WorkSheets(i).Shapes("CommandButton3").Shadow = True (or False) doesn't work! Buy you a pint next time I see you. regards, -- Les Hay, Livingston. Scotland |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is correct syntax when using Scheduled Tasks? | Excel Discussion (Misc queries) | |||
Correct syntax for IF, Then in a macro | Excel Worksheet Functions | |||
Correct Syntax | Excel Discussion (Misc queries) | |||
Correct VBA syntax | Excel Discussion (Misc queries) | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions |