LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default macros don't work if opened using IE

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL WORK BOOK DUPLICATES WHEN OPENED Asoka Walpitagama - Brandix College IT Excel Discussion (Misc queries) 1 November 18th 09 02:25 PM
VBA Excel project won't work when opened in intranet MVM Excel Programming 0 February 1st 05 07:23 PM
Links to other sheets only work if the sheet is opened Arnold de Lange Excel Discussion (Misc queries) 3 December 28th 04 03:12 PM
Prevent the Macros to be opened in 2nd xls. Sheet Bernie Deitrick Excel Programming 1 August 10th 04 07:27 PM
Workbook opened with macros disabled Alan.Hutchins Excel Programming 1 July 28th 04 09:44 AM


All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"