ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel CommandBars (https://www.excelbanter.com/excel-discussion-misc-queries/213622-excel-commandbars.html)

Daniel Utsch[_2_]

Excel CommandBars
 
Does anybody know how I solve this problem?

Error while switching the Excel Command bars (Standard = False)...

Because this error I can't open the file.

Thanks

Gord Dibben

Excel CommandBars
 
Just the one workbook produces this error?

Hold down SHIFT key while opening the workbook to prevent code from running.

Then look through the workbook modules for the source.

Most likely in Thisworkbook module.


Gord Dibben MS Excel MVP

On Sun, 14 Dec 2008 07:33:01 -0800, Daniel Utsch
wrote:

Does anybody know how I solve this problem?

Error while switching the Excel Command bars (Standard = False)...

Because this error I can't open the file.

Thanks



Daniel Utsch[_2_]

Excel CommandBars
 
Yes one workbook file produce this erro. But the VBA project is Locked, and I
don't have de password.

Is there other way of this to solve?

"Gord Dibben" escreveu:

Just the one workbook produces this error?

Hold down SHIFT key while opening the workbook to prevent code from running.

Then look through the workbook modules for the source.

Most likely in Thisworkbook module.


Gord Dibben MS Excel MVP

On Sun, 14 Dec 2008 07:33:01 -0800, Daniel Utsch
wrote:

Does anybody know how I solve this problem?

Error while switching the Excel Command bars (Standard = False)...

Because this error I can't open the file.

Thanks




Gord Dibben

Excel CommandBars
 
Who is the original author of the workbook?

Could you get a password from that source?

Is the workbook a "shared" workbook?

If so, unshare it to release the locked project.

Are you trying to open a workbook created in a later version of Excel than
you are currently running?


Gord


On Sun, 14 Dec 2008 10:50:05 -0800, Daniel Utsch
wrote:

Yes one workbook file produce this erro. But the VBA project is Locked, and I
don't have de password.

Is there other way of this to solve?

"Gord Dibben" escreveu:

Just the one workbook produces this error?

Hold down SHIFT key while opening the workbook to prevent code from running.

Then look through the workbook modules for the source.

Most likely in Thisworkbook module.


Gord Dibben MS Excel MVP

On Sun, 14 Dec 2008 07:33:01 -0800, Daniel Utsch
wrote:

Does anybody know how I solve this problem?

Error while switching the Excel Command bars (Standard = False)...

Because this error I can't open the file.

Thanks






All times are GMT +1. The time now is 02:38 PM.

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