Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an exls file wherein, when file is opened adds a Temp Menu and Items
to the Worksheet Menu Bar by macros. The Temp Menu is populated with the sheet names of the workbook opened. This works fine when opened using excel application. However when the file is saved on an FTP and opened by IE the macro does not work. It only adds the Temp Menu Bar to the Menu Bar and is not populated with Workbook sheet names. Also the Insert, Format, Tools, Data - Menus are not activated. I guess we use the "Worksheet Menu Bar" Commandbar name. when we should use "Menu Bar" Commandbar name. Even Pivot Update by macros of updating more than one Pivot in a same sheet does work but does not refersh the sheet of the update only refresh on selecting another sheet and coming back to it. Now how I get the macro working. when opened by IE. Any suggestions.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL WORK BOOK DUPLICATES WHEN OPENED | Excel Discussion (Misc queries) | |||
VBA Excel project won't work when opened in intranet | Excel Programming | |||
Links to other sheets only work if the sheet is opened | Excel Discussion (Misc queries) | |||
Prevent the Macros to be opened in 2nd xls. Sheet | Excel Programming | |||
Workbook opened with macros disabled | Excel Programming |