LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default error "The macros in this project are disabled"

I can create small VBA/Excel macros and functions and run them just fine.
But when I insert a large function ("xxx"), put "=xxx()" into a cell,
and click F9, VBA complains that "The macros in this project are disabled."

This never used to happen; But I recently had my IBM thinkpad T23 replaced
and my files restored onto the new HD.

The help message suggests that this is because the .wks was opened "with
macros disabled", and suggests that I close it, then reopen it "with macros
enabled".

How do I do that? And is that really the problem?

How do I get around this problem?

I'm running Excel 2000 on Windows 2000, version 5.0, service pack 4.

Thanks in advance for your help!



 
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
"excel "macros may be disabled" message using an xlam file frustrated Excel Worksheet Functions 2 July 13th 09 08:32 PM
"Data Connections have been disabled" If no macros, Why? [email protected] Excel Discussion (Misc queries) 1 October 13th 07 01:26 AM
Excell error "Can't find Project or Library" Project VBAProject Lost in Excel Excel Worksheet Functions 0 April 12th 07 04:42 PM
"Compile Error Can't find project or library." mike allen[_2_] Excel Programming 3 August 10th 05 04:39 PM
Trim: Excel 97 gives error "Can't find project or library" Jim Mooney Excel Programming 10 August 30th 04 08:22 PM


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