Excel VBA

[bronc]

I read that when ActiveX controls (e.g. CommadButton) are placed on a worksheet, some properties and methods are disabled e.g Sort. I don't seem to have any problem with Sort using a Command Button. Can anyone help me with what limitations there may be using a Command Button on a sheet to run code?

 

[Chattin]

http://www.mrexcel.com/board2/viewtopic.php?t=63825

 

[xlbo]

main issue is with the "takefocusonclick" property of the button which can cause some issues with referencing the sheet / cell objects

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[bronc]

thanks for your trouble
Am i right in saying that it was remedied in 2000. i was wondering what methods beside Sort were affected.