Solved: Worksheet Buttons Control and/or Restrictions

[coliervile]

I have a worksheet that contains several buttons on the face of the worksheet that activates different macros and userforms. I want to be able to set the size, width and access of these buttons. I want to restrict the user from altering, changing or deleting the buttons, but still allow the user to click the button to activate the macro or userform. Is this possible through a macro??? I've searched on VBA Express and the internet without success. Does anyone have any ideas?

Best regards,

Charlie

[mdmackillop]

Try

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

[coliervile]

How's your day going Mr. mdmackillop? Thanks for the idea. Would I just put this in a Private Sub?

Best regards,

Charlei

[mdmackillop]

Not so good now. Ireland have just gone into a 7-0 leead at the rugby!
re the code line, just put it in a sub.

[Bob Phillips]

19-6 now!

[mdmackillop]

:boohoo

[Bob Phillips]

How did they get so far behind. In the first half they completed 94 passes to Ireland's 22. They were playing weel, they just had no cutting edge in the backs.

[mdmackillop]

It's a rare ability!

[coliervile]

Thanks "MD', "xld" and you have a great day. I'm sure we'll cross paths again.

Best regards,

Charlie