Macro Security Error No Macro

V

Val Steed

One of my attendees in class yesterday had an error that I could not
resolve. He was receiving a Macro Security warning but had no VBA code in
the file, no Macro Module in the file and Security set to Low.

Any ideas?

Val Steed
(e-mail address removed)
 
R

Ronald Dodge

Did you go into the Visual Basic Editor (VBE) side of Excel (Either
Tools>Macros>Visual Basic Editor or Alt-F11), and check under each of the
Excel objects to see if there was any code in any of them objects?

I have ran into this sort of issue before in the past, particularly when we
for a while ran XL97 on W2K system, cause until a power user or above opened
an Excel file that had any sort of a macro in it (since the last time Office
97 was installed on the system), even if it was just some declaration thing
under one of the Excel objects, it still denied the restricted standard
users from being able to open the file stating that permission to use
objects denied. Once a power user did open a file that had any sort of
macro, then was restricted standard users able to open macro files. What
Excel was trying to do in that situation, it was trying to write to the
system registry with regards to VBA, but given the restricted access to it
for restricted standard users, this caused the error. This was a one time
operation type deal by nature per system.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top