Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default A macro disabled message comes up but there is no macro.

When I open a particular spreadsheet, a message comes up saying a macro has
been disabled due to high security. But I never set up a macro on the
spreadsheet so I don't know how to make the message stop.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 154
Default A macro disabled message comes up but there is no macro.

Could this be due to the excel document having been created in a previous
version of Excel?
One way to make this stop would be to change the security settings in Excel.

ToolsMacroSecurity...Low (or not High)

Another would be to check the VBA for coding:

ToolsMacroVisual Basic Editor
From here search every tab to ensure that there infact is no coding present.

--
--Thomas [PBD]
Working hard to make working easy.


"lovetocount" wrote:

When I open a particular spreadsheet, a message comes up saying a macro has
been disabled due to high security. But I never set up a macro on the
spreadsheet so I don't know how to make the message stop.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default A macro disabled message comes up but there is no macro.

Look at Debra Dalgleish's site:
http://contextures.com/xlfaqMac.html#NoMacros

lovetocount wrote:

When I open a particular spreadsheet, a message comes up saying a macro has
been disabled due to high security. But I never set up a macro on the
spreadsheet so I don't know how to make the message stop.


--

Dave Peterson
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 Buttons and Items in Developer Tab disabled Carey Campbell Excel Discussion (Misc queries) 1 April 21st 08 09:09 PM
Validation disabled on international macro sheet Stefi Excel Discussion (Misc queries) 4 March 8th 07 03:06 PM
Message Box Macro Heather O'Malley Excel Discussion (Misc queries) 3 August 22nd 06 09:13 AM
Message box macro Heather O'Malley Excel Discussion (Misc queries) 3 July 21st 06 12:43 PM
Message box before another macro michaelberrier Excel Discussion (Misc queries) 9 May 22nd 06 12:39 AM


All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"