create buttons in

[nilsanp]

I've recorded a macro where i create a button

Please Login or Register  to view this content.

pretty straight forward.

I dont like to use ".select" too much, since that is recording-language. That means excel select it, and i dont need that.

To me, it would make sense if i could use

Please Login or Register  to view this content.

why doesnt this add a button?

I've tried to declare the variable, but i dont know what the variable for button is. Theres no such thing as controlbutton, commandbutton, or simply, button.

Anyone familiar with any of this?

[Domski]

Maybe something like this:

Please Login or Register  to view this content.

Dom

[nilsanp]

I thought i had tried that as well, but obviously i hadnt.

Since i have you here. What would you use to protect the buttons of a sheet? Do i use the protect-property of the sheet?

[Domski]

Yes, protecting the worksheet should do the trick as long as the ability to Edit Objects isn't enabled.

Dom