ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Permission to use object denied. (https://www.excelbanter.com/excel-programming/305718-permission-use-object-denied.html)

Shannon

Permission to use object denied.
 
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".


Tom Ogilvy

Permission to use object denied.
 
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.

--
Regards,
Tom Ogilvy

"Shannon" wrote in message
...
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".




WilDeliver[_2_]

Permission to use object denied.
 
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

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"Shannon" wrote in message
...
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".





[email protected]

Permission to use object denied.
 
check to see you have local administrator rights, I try that it work

"WilDeliver" wrote:

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

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"Shannon" wrote in message
...
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".






All times are GMT +1. The time now is 06:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com