Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default hidden macro affects how other files open

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
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
Macro - Open all word files in a directory Dileep Chandran Excel Worksheet Functions 11 December 19th 06 02:12 PM
Open several text files using a macro Jade5 Excel Discussion (Misc queries) 0 October 31st 06 02:01 AM
Macro to open files isn't updating correctly telewats Excel Discussion (Misc queries) 2 February 21st 06 09:04 PM
Macro for multiple open files [email protected] Excel Discussion (Misc queries) 1 February 13th 06 03:25 AM
file open via IE hyperlink causes already open files to shrink and tile Marc Setting up and Configuration of Excel 0 May 4th 05 08:13 PM


All times are GMT +1. The time now is 12:48 AM.

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"