view code

K

kalim

Board Regular
Joined
Nov 17, 2010
Messages
87
Hi excel users.

Can someone please tell me why the following code does not work in Excel 2010. It works fine in Excel 2007, but it does nothing in Excel 2010.

Code: 
Application.CommandBars("Ply").Controls("view code").Visible = False

Thanks.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
I am in 2000 at the moment. In 2010, is the accelerator the same? Have you tried including the ampersand? A quick/blind stab of course.
 
Upvote 0
Thanks for the reply.

I have tried it with the ampersand and still no luck.

Code: 
Application.CommandBars("Ply").Controls("&view code").Visible = False

Any ideas why it does not work in Excel 2010?
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
Enable sheet tab right click
Replies
6
Views
1K
Eric Carolus
E
G
  • Question Question
Making transparent solid 3D model
Replies
0
Views
200
gifariz
G
I
  • Question Question
duplicate entry restriction VBA Code causing issue in other portion
Replies
9
Views
94
Alex Blakenburg
A
I
  • Question Question
Enter value in textbox userform from a closed sheet on my pc
2 3
Replies
21
Views
205
ipbr21054
I
A
  • Question Question
Excel file on SharePoint used at the same time
Replies
1
Views
145
ExcelToDAX
E

Forum statistics

Threads
1,224,587
Messages
6,179,734
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top