Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a macro sitting in the folder
C:\Documents and Settings\user-name\Application Data\Microsoft\Excel \XLSTART The worksheet in the excel file with macro itself is "hidden". When I open other excel files they would not show data upon opening. I need to do Windows, Unhide, Cancel to get them to show data. Instead of Cancel in the Unhide popup window I can select the macro (which is the only name in it which makes sense as the real file with data is not hidden) and unhide it - the file with data will also show... The problem exist only on one computer - same macro on other machines does not prevent other files to be visible upon opening. If I delete the file with macro, everything opens up normally. So, the fact that a file with hidden worksheet exists in the XLSTART folder somehow affects what Excel shows. I assume an Excel setting on that machine should be tweaked but do not see which one. Any ideas? Thanks a lot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro - Open all word files in a directory | Excel Worksheet Functions | |||
Open several text files using a macro | Excel Discussion (Misc queries) | |||
Macro to open files isn't updating correctly | Excel Discussion (Misc queries) | |||
Macro for multiple open files | Excel Discussion (Misc queries) | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel |