LinkBack URL
About LinkBacks
hi,
I have a line in my code
"Sheets("Front Graphs").Shapes("Button 2").ControlFormat.Enabled = False"
This code is working in Excel 2007 But when i open same workbook in excel 2010,This does not work.
Any clue??
hi,
I have a line in my code
"Sheets("Front Graphs").Shapes("Button 2").ControlFormat.Enabled = False"
This code is working in Excel 2007 But when i open same workbook in excel 2010,This does not work.
Any clue??
I have found that with shapes you need to select them first.
Maybe try:
abousetta
Please Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
the problem is still same..I tried it but nothing happened.
What type of control? Forms or ActiveX
Not sure you can disable a Forms control.
code for Activex without selection
Please Login or Register to view this content.
for formcontrols use:
@aboussettaPlease Login or Register to view this content.
I found the opposite: no selection necessary
All these codes are equivalents:
Please Login or Register to view this content.
Last edited by snb; 11-30-2011 at 06:51 AM.
@snb, can you post an example because my testing of this on a forms control has now effect.
Activex control when disabled has greyed out caption and can not be clicked with the forms button I am not seeing any difference in appearence or use.
@Andy
I could, but it would have no use, since I can't find any difference for formcontrols either.
The only thing I can perceive is that the code works and changes that property using e.g.
x2=sheets(1).buttons(1).enabled
So maybe 'This code is working in Excel 2007' is true, but without any visual/factual result.
I've tried in '03/07/10. Whilst the code does not error it can not see it has any effect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks