Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Synchronizing multiple worksheets in a workbook (Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2003 Worksheets | Excel Discussion (Misc queries) | |||
How many worksheets can I add on a workbook for Excel XP | Excel Discussion (Misc queries) | |||
Excel Worksheets within a Workbook | Excel Worksheet Functions | |||
Excel 2003 Workbook into Word 2003 | Excel Discussion (Misc queries) |