Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick menus not working
I have a spreadsheet that replaces the usual quick menus with some of my
own. On all my work computers it works fine, except one (a Sony Vaio notebook). The version of excel is the same but on the Sony the usual quick menus appear and my vba created ones don't. Does anyone have any idea where I should start looking for an answer to this? Tony Armstrong |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick menus not working
Hi Tony,
This is an Excel issue and is independent of the computer. If the personalised menus are set up and removed with event code - possibly in the Workbook Open and BeforeClose events - it is possible that events were turned off when the file was loaded. To rectify, or to exclude this possibility, prior to loading the problematic workbook, type the command: Application.EnableEvents = True in the Immediate window and hit Enter. --- Regards, Norman "BowMag" wrote in message ... I have a spreadsheet that replaces the usual quick menus with some of my own. On all my work computers it works fine, except one (a Sony Vaio notebook). The version of excel is the same but on the Sony the usual quick menus appear and my vba created ones don't. Does anyone have any idea where I should start looking for an answer to this? Tony Armstrong |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick menus not working
another thought
on the Vaio : look at the .Protection property of the commandbar where you are adding your controls. It may include the MsoBarNoCustomize flag. (accidental or intentional you never know) The property is a long which is the combination of several flags. see help on "Protection Property (Office) for details on the various flags. (msoBarprotection constants) to circumvent these issues i use code like: with commandbars(x) lProt = .protection ..protection=0 'do your stuff ..protection=lProt end with -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam BowMag wrote : I have a spreadsheet that replaces the usual quick menus with some of my own. On all my work computers it works fine, except one (a Sony Vaio notebook). The version of excel is the same but on the Sony the usual quick menus appear and my vba created ones don't. Does anyone have any idea where I should start looking for an answer to this? Tony Armstrong |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customizing Menus and Quick Access Toolbar in 2007 | Setting up and Configuration of Excel | |||
excel 2007 customize quick access toolsbar adding menus commands | Excel Discussion (Misc queries) | |||
Quick q' about working with numbers | New Users to Excel | |||
Working with and adding Menus? | Excel Programming | |||
Excel in Internet Explorer Menus quit working | Excel Discussion (Misc queries) |