VBA Command Button not formatting

[jimrosser]

Hoping someone can help with this.

I've got the following code that works when run on it's own but when I put it to run / called in a module it only inserts the command button but no formatting. The sheet is not protected however the command button says protected in the formatting. Any help would be greatly appreciated.

Please Login or Register  to view this content.

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[jimrosser]

Thanks Mick! That fixed it.

[MickG]

You're welcome