Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Read-only problem using a frame in Excel

Status
Not open for further replies.
goodmanrAy

goodmanrAy

Programmer
Feb 6, 2002
53
0
0
GB
I have created an excel 97 spread sheet which has a "microsoft forms 2.0 frame" on it. When I change the excel file to read-only (it's going to be used by multi users), the work sheet crashes with an acess violation.

Has anyone else come across this problem, any ideas on getting around it?

Cheers

Andrew
 
Sort by date Sort by votes


Have you checked the microsoft knowledgebase?

Skip,
[sub]
[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue][/sub]
 
Upvote 0 Downvote
Yes I checked it out. Couldn't find anything.

Cheers

Andrew
 
Upvote 0 Downvote


Do you get an error message?

Skip,
[sub]
[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue][/sub]
 
Upvote 0 Downvote
Hi Skip

This error occurs when I try to open the excel spread sheet.
I click OK and excel closes.


The instruction at "0x30155b77" referenced memory at "0x00000004". The memory could not be "read".

I have tried it on a different machine and same problem.
If you have excel 97 and a bit of time, give it a bash.


Cheers

Andrew

 
Upvote 0 Downvote


I don't have 97 at the office.

Does this happen if you save the workbook as read only WITHOUT any embedded controls?

Skip,
[sub]
[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue][/sub]
 
Upvote 0 Downvote
Hi Skip

It only happens when I add a Frame to the excel spread sheet, and set the file to read only. I've had a good browse on the web for any info on such a bug, but have come across nothing. Am a bit stumped, as I've spent a week creating an elaborate spread sheet with a few frames on it. Now when a user comes to open it, when it is being used by someone else, it crashes.

cheers

Andrew
 
Upvote 0 Downvote


Have you read up on WORKBOOK SHARING -- pros & cons/limitations?

Have you set the parameters for Workbook Sharing?

Skip,
[sub]
[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue][/sub]
 
Upvote 0 Downvote


Also, when you refer to a frame, what do you actually mean? Is this a MS Excel 5.0 Dialog Frame that you design by inserting a dialog sheet?

Skip,
[sub]
[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue][/sub]
 
Upvote 0 Downvote
Hi Skip

It's a "microsoft forms 2.0 frame" found in the Control Toolbox (excel 97). When I create a shared workbook with a "microsoft forms 2.0 frame" on it, it crashes.

Cheers

Andrew

 
Upvote 0 Downvote


Can you open 2 instances of this workbook yourself?

Skip,
[sub]
[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue][/sub]
 
Upvote 0 Downvote
Hi Skip

I'm confused, how do you open two instances of the same workbook in excel?

Andrew
 
Upvote 0 Downvote
Hi Skip

Just tried opening two instances in two different excel sessions, and no I couldn't, the second one crashed.

I think this could be an excel bug.

cheers
Andrew
 
Upvote 0 Downvote


I can open 2 instances of a read-only workbook containing one frame.

Skip,
[sub]
[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue][/sub]
 
Upvote 0 Downvote
Hi Skip

Are you using Excel 97. I've tested it using later versions and it works fine. It's just Excel 97 where it raises an error, with me.

Andrew

 
Upvote 0 Downvote


Sorry, I forgot. My 97 version is at home.

I'll have to try it this evening.

Skip,
[sub]
[glasses] [red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
3
Views
143
strongm
strongm
remeng
  • Locked
  • Question
Multiple Users in a Macro enabled Excel Doc
Replies
0
Views
86
remeng
remeng
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
185
huiettcm
huiettcm
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
105
Andrzejek
Andrzejek
f0rg3tfu1
  • Locked
  • Question
VBA Error in Excel
Replies
11
Views
179
combo
combo

Part and Inventory Search

Sponsor

Back
Top