SOLVED

Hide worksheet

Copper Contributor

Hi everybody,

 

I have a problem. I want to hide a workbook, but this function is not available. How can I solve this? (see image: 'verbergen' = hide)

 

Hanneke2445_0-1655190558189.png

 

2 Replies
best response confirmed by Hanneke2445 (Copper Contributor)
Solution

@Hanneke2445 

I see that you also can't insert a new worksheet or delete one. If the workbook structure is protected
with a password, you're unable to add, delete, move, copy, remane, hide or unhide sheets.

Check if you're using a protected workbook.

1. Go to FILE -> Info
2. If it is protected with a paswoord you have to type in the correct paswoord to unprotect the workbook. 

BeyK40_0-1655193859849.png

 

@BeyK40 

 

Yes thank you! It worked! 

 

 

1 best response

Accepted Solutions
best response confirmed by Hanneke2445 (Copper Contributor)
Solution

@Hanneke2445 

I see that you also can't insert a new worksheet or delete one. If the workbook structure is protected
with a password, you're unable to add, delete, move, copy, remane, hide or unhide sheets.

Check if you're using a protected workbook.

1. Go to FILE -> Info
2. If it is protected with a paswoord you have to type in the correct paswoord to unprotect the workbook. 

BeyK40_0-1655193859849.png

 

View solution in original post