Freeze Panes Problem for one of my users

[DrSmyth]

Hi, We're using XL97 for a few spreadsheets and one of my users seems to be having a few problems with Frozen panes.

Basically she can use frozen panes for most spreadsheets, but for one particular spreadsheet, frozen panes just don't seem. I've got her to check the window menu and there's only an option to unfreeze panes (indicating that the panes are frozen).

This is the only workbook that she's having these problems with. If it's relevant, the workbook is shared.

Something else that may be relevant is the fact that her Tools>Share Wookbook option in the menu is greyed out (meaning she can't change any of the settings.....) it's all very frustatrating.... Has anybody come across this before??? And does anybody have a solution???

Thanks

Dr

 

[xlbo]

Sounds like a protected copy of a shared workbook with her not being the owner of the protection - don't really use shared workbooks due to the headaches they cause so not that up on 'em but you will need to get anyone who uses it to have a look and see if they've protected the structure of the book from everyone else...

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[01Patrik]

In later versions the grayed out option would indicate that the share is protected (tools, protection, portect shared workbook) with a password.

I suppose you mean she cannot unfreeze the panes? If she can, can she freeze them again?

Since VBA cannot be edited in shared mode, can you unlock and check for workbook_open or workbook_close events?

Cheers

// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.

 

[DrSmyth]

It does look like the share is protected, but there's nothing in the open routine to indicate this.... Gonna take it off shared and see if i can get her to share the workbook and see if it'll wor that way..

Cheers

 

[gizmo1973]

You'll probably find that once you un share the workbook the un protect facility is now available.
In shared mode you cannot un protect.

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts