Permission to use object denied.

S

Shannon

I have a user on a Windows 2000 machine with user rights.
The user is also running office 97. When he opens a excel
speedsheet and Enable's Macros, he gets the following
message; "Permission to use object denied".
 
T

Tom Ogilvy

remove any files in the xlStart directory (except for personal.xls). Also
go into Tools=>Addins, and uncheck any non-standard addin.

If that clears up the problem, start adding back things one at a time and
then close and start excel and until you find the one that is causing the
problem.
 
W

WilDeliver

I've got essentially the same problem. Excel97 running under Windows XP.
When I try to open a workbook I get this dialog box:
MS Visual Basic
Permission to use object denied
This happens whether I open from a floppy or from the file copied onto the
desktop.
The same file and floppy work on other computers.

Opened XLStart, removed the only file there. Still no go.
Opened a new workbook and looked in AddIns. Tried removing following
add-ins, but received same dialog box for each.
Conditional Sum Wizard
File Conversion Wizard
Lookup Wizard
Web form Wizard

Other suggestions?
Thanks
GaryG
 

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