LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 896
Default no worksheets in a workbook - Excel 2003

Hi,
I have a workbook with several worksheets (10) and 7 VBAProject
modules (with numerous procedures). The workbook is used to perform
calculations on a daily basis. After the calculation is complete the
results are saved as a daily file (containing 5 worksheets with values
only = no formulae, no macros/procedures).

Last Monday a file was created but when I try to open it is showing me
a macro alert warning (as if there were macros in the file while there
should not be any!). Monday's file is 23,5 kB while normally it is ca.
400 kB.

When I click on the button turning OFF macros in the workbook I get a
warning stating (more or less cause I am translating it from my
regional version) that "This workbook contains MSExcel 4 macros that
cannot be turned off. It may contain viruses. If the workbook is from
a trusted location then click Yes. Open it?" The only MSExcel 4 macro
I am using is GetValue function.

When I click on the button turning the macros ON nothing happens = no
file gets opened and the screen is "blank".

When I go ALT+F11 to look for xlHidden/xlVeryHidden sheets the
VBAProject window is greyed out and shows no objects. Insert-Module
and most of other menus are also greyed out.

Could anyone pls explain what is going on? or suggest a remedy?

Thks
Jarek
 
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
Synchronizing multiple worksheets in a workbook (Excel 2003) jms Excel Discussion (Misc queries) 1 February 12th 08 08:41 PM
Excel 2003 Worksheets Bowtie63 Excel Discussion (Misc queries) 2 October 3rd 07 03:24 PM
How many worksheets can I add on a workbook for Excel XP Elda Excel Discussion (Misc queries) 3 April 3rd 07 09:44 PM
Excel Worksheets within a Workbook Lisa Excel Worksheet Functions 3 January 4th 07 12:04 PM
Excel 2003 Workbook into Word 2003 B. Levien Excel Discussion (Misc queries) 4 September 26th 06 09:52 PM


All times are GMT +1. The time now is 06:52 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"