Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

VBA problem... command doesn't appear to work

Thread Tools
 
Search this Thread
 
Old Jul 31, 2003 | 12:38 PM
  #1  
Mick's Avatar
Mick
Thread Starter
Scooby Senior
iTrader: (1)
 
Joined: Nov 1998
Posts: 2,656
Likes: 4
Unhappy

I have enjoyed making a little calendar function for Excel as demonstrated at : http://www.fontstuff.com/vba/vbatut07.htm

Getting adventurous I continued the tutorial getting to add the command to the in-cell shortcut menu at Excel opening.

Unfortunately I have now 5 copies of the cmmand on my menu due to not being able to get the delete part of the command working - either in the 'Before Workbook close' function or in the 'Immediate Window'

The text from the webpage is as follows:
enter the line:

Application.CommandBars("Cell").Controls("Insert Date").Delete

...which removes your item from the shortcut menu of a cell. Your finished code should look like this:

*Picture*

TIP: If you should find yourself with unwanted copies of custom menu items on the shortcut menu (because, like me, you wanted to test the first procedure before you created the second one!). You can give the instruction from the Visual Basic Editor's Immediate Window (go to View > Immediate Window or Keys: CTRL+G). Click in the Immediate Window and type the line the starting Application... and ending ...Delete then press [ENTER].

The line refered to above... should it start 'the starting Application...' or just 'Application...' ????

Cheers

Mick
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
aaron_ions
General Technical
17
Nov 3, 2021 11:07 AM
Mattybr5@MB Developments
Full Cars Breaking For Spares
20
Oct 22, 2015 06:12 AM
ALi-B
Computer & Technology Related
0
Sep 14, 2015 07:49 AM




All times are GMT +1. The time now is 01:54 PM.