Excel page cannot be viewed
Solved
Kris
-
PapyLuc51 Posted messages 4567 Registration date Status Member Last intervention -
PapyLuc51 Posted messages 4567 Registration date Status Member Last intervention -
Hello,
in my XLS file, there is a sheet that I cannot see.
It is hidden and some elements are referenced within it, but I need to modify them, and it’s IMPOSSIBLE.
What should I do?
1- xlsheetvisible, it gives me the following error message: Cannot set the Visible property of the Worksheet class.
I haven't set any protection.
in my XLS file, there is a sheet that I cannot see.
It is hidden and some elements are referenced within it, but I need to modify them, and it’s IMPOSSIBLE.
What should I do?
1- xlsheetvisible, it gives me the following error message: Cannot set the Visible property of the Worksheet class.
I haven't set any protection.
21 answers
- 1
- 2
Next
Hello
Press Ctrl+A to select the entire sheet; right-click on the letter of a column and then select "Unhide".
Best regards
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
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.
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
Best regards
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, 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
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
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
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!!!
And the person who created the file is no longer here!!!
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.
so it must be possible to just display a sheet... but how... that is the question.
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
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
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...
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
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
https://www.bonbache.fr/faire-sauter-la-protection-des-feuilles-excel-160.html
- 1
- 2
Next