Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook view with internet explorer
The few lines of code below are the opening lines of a subroutine in a
workbook. When run directly in excel they work as expected but when other users access the workbook using internet explorer a problem occurs. When the Menu worksheet is made invisible and the Logistics worksheet is selected. Instead of switching from one sheet to the next, the 2 sheets become superimposed and only refresh and switch to the Logistics sheet when the calculations that go on lower down in the subroutine are completed. Any thoughts? Sub Logistics() On Error Resume Next Worksheets("Month").Cells(17, 1).Value = Now() Worksheets("Menu").Visible = False Worksheets("Logistics").Select etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set View to 75% upon Workbook open | Excel Worksheet Functions | |||
Can I view multiple tabbed worksheet in the same workbook in Excel | Excel Discussion (Misc queries) | |||
View Workbook Links | Excel Discussion (Misc queries) | |||
MAKING EXCEL AS HOME PAGE IN INTERNET EXPLORER | Excel Discussion (Misc queries) | |||
Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) |