| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Item Deleted
In one excel file, in the ThisWorkbook object, in the Private Sub
Workbook_Open() event, I entered the this line of code: Application.CommandBars(1).Name("Format").Delete The intent was to disable FormatSheetsunhide to the users in this particular file. Format has gone away in all instances of Excel and reinstalls do not cure the problem. I am at a loss. Can anyone help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Menu Item Deleted
Hi Caddy
I think you used Application.CommandBars(1).Controls("Format").Dele te You can reset it like this Application.CommandBars(1).Reset For more information see http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Caddy Shack" wrote in message ... In one excel file, in the ThisWorkbook object, in the Private Sub Workbook_Open() event, I entered the this line of code: Application.CommandBars(1).Name("Format").Delete The intent was to disable FormatSheetsunhide to the users in this particular file. Format has gone away in all instances of Excel and reinstalls do not cure the problem. I am at a loss. Can anyone help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Menu Item Deleted
BTW, the code you want is
Application.CommandBars(1).Controls("Format").cont rols("Sheet").controls("Un hide...").enabled=false -- HTH RP (remove nothere from the email address if mailing direct) "Ron de Bruin" wrote in message ... Hi Caddy I think you used Application.CommandBars(1).Controls("Format").Dele te You can reset it like this Application.CommandBars(1).Reset For more information see http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Caddy Shack" wrote in message ... In one excel file, in the ThisWorkbook object, in the Private Sub Workbook_Open() event, I entered the this line of code: Application.CommandBars(1).Name("Format").Delete The intent was to disable FormatSheetsunhide to the users in this particular file. Format has gone away in all instances of Excel and reinstalls do not cure the problem. I am at a loss. Can anyone help? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Menu Item Deleted
Hi Caddy
If your workbook will also be used in non US Excel versions use the ID numbers of the control(see my site). If not use Bob's example -- Regards Ron de Bruin http://www.rondebruin.nl "Bob Phillips" wrote in message ... BTW, the code you want is Application.CommandBars(1).Controls("Format").cont rols("Sheet").controls("Un hide...").enabled=false -- HTH RP (remove nothere from the email address if mailing direct) "Ron de Bruin" wrote in message ... Hi Caddy I think you used Application.CommandBars(1).Controls("Format").Dele te You can reset it like this Application.CommandBars(1).Reset For more information see http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Caddy Shack" wrote in message ... In one excel file, in the ThisWorkbook object, in the Private Sub Workbook_Open() event, I entered the this line of code: Application.CommandBars(1).Name("Format").Delete The intent was to disable FormatSheetsunhide to the users in this particular file. Format has gone away in all instances of Excel and reinstalls do not cure the problem. I am at a loss. Can anyone help? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Menu Item Deleted
Ron,
I keep forgetting that. Thanks Bob "Ron de Bruin" wrote in message ... Hi Caddy If your workbook will also be used in non US Excel versions use the ID numbers of the control(see my site). If not use Bob's example -- Regards Ron de Bruin http://www.rondebruin.nl "Bob Phillips" wrote in message ... BTW, the code you want is Application.CommandBars(1).Controls("Format").cont rols("Sheet").controls("Un hide...").enabled=false -- HTH RP (remove nothere from the email address if mailing direct) "Ron de Bruin" wrote in message ... Hi Caddy I think you used Application.CommandBars(1).Controls("Format").Dele te You can reset it like this Application.CommandBars(1).Reset For more information see http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Caddy Shack" wrote in message ... In one excel file, in the ThisWorkbook object, in the Private Sub Workbook_Open() event, I entered the this line of code: Application.CommandBars(1).Name("Format").Delete The intent was to disable FormatSheetsunhide to the users in this particular file. Format has gone away in all instances of Excel and reinstalls do not cure the problem. I am at a loss. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| item numbers in a list that update if a row is deleted | Excel Discussion (Misc queries) | |||
| Suddenly deleted Tools Menu | New Users to Excel | |||
| Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
| Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
| deleted item | Excel Programming | |||
Hybrid Mode
