Unfreeze panes not working

[r0bism123]

Hello,

I'm having an issue unfreezeing panes throughout multiple pages of my workbook. I've unlocked the workbook structure and all of the sheets in the workbook and the freeze pane icon remains greyed out.

I researched other threads on this issue and I verified the workbook is not protected, there is no split screens on any of the sheets nor am I in Page Layout View.

What is interesting, under File --> Info --> Protect Workbook, there is a yellow box and it says, "The Structure of the workbook has been locked to prevent unwanted changes, such as moving, deleting or adding sheets." It seems to be permanately locked for some reason. I've tried 100 times to unlock the workbook structure via Review --> Protect Workbook and under File --> Info --> Protect Workbook --> Protect Workbook Structure.

Any ideas to fix this issue? Thanks in advance.

 

[petertenthije]

Your sheet might ha e a password set to it, that could deny you from changing the layout (un/freeze panes).

 

[r0bism123]

Your sheet might ha e a password set to it, that could deny you from changing the layout (un/freeze panes).

No, all of the tabs and the workbook structure is unprotected. I even saved this as test file and deleted every tab and module in the workbook. Sheet81 is unable to be deleted which is where I believe the problem lies. If I could just delete that sheet, I think I solve my problem here.

 

[petertenthije]

Are there external workbooks / databases linked to your excel file? Or is there a VBS script that could open this database? That might have blocked your file as well if the linked file is still open, or the VBS is still running.

 

[r0bism123]

Here is a screen shot of what I'm talking about...

 

[Fluff]

That shows that your workbook has become corrupted, it's not a sheet it's another ThisWorkbook module.

 

[r0bism123]

Are there external workbooks / databases linked to your excel file? Or is there a VBS script that could open this database? That might have blocked your file as well if the linked file is still open, or the VBS is still running.

No, there is nothing in this file. I deleted everything and sheet81 still remains. It's very odd.

 

[r0bism123]

That shows that your workbook has become corrupted, it's not a sheet it's another ThisWorkbook module.

****. Any way to fix this without recreating the entire workbook?

 

[Fluff]

Not that I'm aware of unfortunately. There maybe add-ins available to do that, but couldn't say for certain.

 

[r0bism123]

Not that I'm aware of unfortunately. There maybe add-ins available to do that, but couldn't say for certain.

My fix was to move/copy all of the tabs from one workbook into a new workbook file.

Then, I needed to bring my VBA over into the new file and make sure everything worked. Took about 2 hours night.

The second ThisWorkbook “sheet81” turned into a normal sheet and I was then able to delete. Freeze panes works like a charm now. ??

 

[Fluff]

Glad you got it sorted & thanks for the feedback