How to disable controls

[daniel50096230]

I would like to know how can I disable the controls at the top there such as the Cut icon,Copy icon.....

 

[mvptomlinson]

Daniel, try googling "excel disable cut copy". You'll get tons of hits, as this has been answered many times on this board and others.

 

[Ivan F Moala]

I would like to know how can I disable the controls at the top there such as the Cut icon,Copy icon.....

This may help ??

http://www.xcelfiles.com/VBA_Quick13.html

 

[Greg Truby]

Nice link, Ivan. Didn't know you had that.


Daniel, a couple of -type notes:

• Taking away staple menu options normally really irritates people.
• You'll need to be able to force the user to enable macros.
• Make sure that you attach the code to the workbook's ACTIVATE/DEACTIVATE methods. Otherwise, if the user has multiple workbooks open you most definitily will annoy them!

 

[daniel50096230]

Great...the link help me a lots....And thanks for everyone who helped me...thanks...