VBA code to copy ActiveSheet.name to the Clipboard?

[actjfc]

Excel friends, this should be an easy one: What is the code to copy the ActiveSheet.name to the clipboard? So, I can paste it anywhere I want outside the Excel workbook. Any help is appreciated. Thanks!

 

[MickG]

Thanks Rory,
If I load a new file The Forms Ctrl is "Unticked", If I Create some code it becomes "Ticked" , this seems to be the Requirement. !!!

 

[RoryA]

Just adding code shouldn't add the Forms reference, unless you add an ActiveX control from the Forms library to a sheet, or add a Userform.

 

[MickG]

Yes I imagine its the "CommandButton", interesting !!!