Excel page cannot be viewed

Hello

Press Ctrl+A to select the entire sheet; right-click on the letter of a column and then select "Unhide".

Best regards

In fact, I can't see the page. It's marked as XlsheetHidden and I can't change it.

I tried this that I found on the net but nothing...

Sub Test()
ActiveWorkbook.Unprotect
End Sub

Hi,

Well, English and I don’t really get along, so VBA is off the table. ;-))

I didn't realize it was a hidden sheet.
If the file is not protected, right-click on one of the tabs, then select "unhide," a window will open with all the hidden sheets, click on the one to open and OK.

After that, I'll leave you in the hands of the VBA specialists.

Best regards.

Hello

if your sheet is hidden and not protected, try this

Sub Test() Dim sh As Worksheet For Each sh In Sheets sh.Visible = True Next sh End Sub

Best regards

Hello, thank you for your reply

> So, for the first one, the answer is

" error 1001 the method "Visible of the object __Worksheet failed "

it highlights the line sh.Visible = True in yellow

> For the second one: nothing more happened... and still no visible sheet.....

> For the third one, same answer as for the first one...

So, mystery

Can you send your file? Maybe a specialist can help you out?

1) Go to https://www.cjoint.com/
2) Click on [Browse] to select your file
3) Scroll down to the bottom of the page to click on [Create Cjoint link]
4) After a few seconds, the second page will appear, with the link
in blue underlined; select it and click "Copy"
5) Return to your conversation on CCM, and in your reply message, click "Paste".

Best regards

Here is the link

I left just the essentials for the calculation

one cell with the value to enter and one cell with the result that takes information from a hidden page.

https://www.cjoint.com/c/KHeg0HCeYlD

Hello,

The entire workbook is password protected.
You need to unprotect it to access the hidden sheet.

Best regards

Yes, that's exactly my problem!!!! I don't know the MP.

And the person who created the file is no longer here!!!

Unfortunately, I don't know if anyone will be able to help on CCM

>>> READ THIS <<<

Best regards

I have already managed to break the MP to be able to modify the visible page because it was blocked and we couldn't change anything...

so it must be possible to just display a sheet... but how... that is the question.

Hello

By using LibreOffice, I got this
https://www.cjoint.com/c/KHekbVe0awB

Best regards

Hi ccm81;
You beat me to it; I was doing the same thing when I saw your response.

Best regards

Sorry, the link is no longer active ......

Could you please reactivate it ... Thank you.

Hello

while waiting for ccm81 to send the link

It's not difficult, you right-click on your file / open with LibreOffice Calc / disable macros /
The file will open with only one sheet

right-click on the sheet / show sheets / click on the first one / Ok and repeat for the other sheets to open

Save as choose Excel 2003-365 with macro

Best regards

TOP

that's great; thanks for the info

????

Hello,

The problem seems to come from the password protection of the workbook and the name of the tab
what is the password used!

Sheet 1 and Sheet 2 contain calculations on more than 30,000 rows and 3 columns and formula errors, however, the Tab Choice scale is empty
A+
Mike-31

I am responsible for what I say, not for what you understand...

In case
https://mon-partage.fr/f/LOWZ0v8T/

Note: The macro is only intended to attempt to remove the password from the active sheet, you can save without the macro since it's no longer needed

Best regards

This could help you, it saved me once!
https://www.bonbache.fr/faire-sauter-la-protection-des-feuilles-excel-160.html

Thank you for everything

great responsiveness