Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 to XP problem
I have some code that works absolutely fines in Excel 97
but is giving "odd" behaviour in XP. It's to do with the right click menu on the worksheet tabs - I'm trying to selectively disable certain aspects (e.g. view code). What used to work is: Application.CommandBars(27).Controls("view code").Enabled = False I've tried to work out how to get this menu control using: For Each ctl In Application.CommandBars("workbook tabs").Controls Debug.Print ctl.Caption Next But this returns the names of each of the worksheets. If I do something like: Application.CommandBars("workbook tabs").ShowPopup I get a menu with the three worksheet names as a menu. Hmm Very confused. Anyone know how I can set these controls to be enabled? Thanks Leyton ps I'd like to keep this working in both Excel 97 and 2002! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) |