In excel 2007 there is no commandbars, how can i write below code for excel 2007. have found some info on below link but doesnt help me out.
http://www.rondebruin.nl/hidevisible.htmhttp://<a href="http://www.rondebru..._blank">www.rondebruin.nl/hidevisible.htm</a>
http://www.rondebruin.nl/hidevisible.htmhttp://<a href="http://www.rondebru..._blank">www.rondebruin.nl/hidevisible.htm</a>
Rich (BB code):
Sub RestoreMenu()
'http://www.computertrouble.co.uk/forum/viewtopic.php?f=11&t=76&start=60
With CommandBars("Worksheet Menu Bar")
With .Controls("Edit")
.Controls("Cut").Enabled = False
.Controls("Copy").Enabled = False
.Controls("Paste").Enabled = False
.Controls("Paste Special...").Enabled = False
End With
End With
End Sub
Last edited: