Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, I have some code that works for displaying different titles and hiding or
displaying info on a worksheet. The problem is it works with the view menu and I need to add more menu items. I can add the Items too the view menu, but they are being added to my default template not to the workbook itself. If I open other workbooks they show up. More importantly if I email the workbook only the original items are in the view menu and not my new additions. One other thing I noticed is that the original menu items seemed to be a group. If I click on one it has a check mark next to it. If I click on another the check mark moves to it. This does not happen on my new items. If I click on them they have no check marks. Any help would be appreciated. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I would suggest that you add the items with a macro linked to the Workbook_Open event and remove them with a similar macro linked to the Workbook_BeforeClose event -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=542639 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Share Workbook is grayed out in the Tools menu | Excel Discussion (Misc queries) | |||
Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
Editing XL95 custom menus with XL97 | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) |