Hide Unused Columns

[tico_ocit]

Hi there,

as you can see on the picture, I have hid the columns from R to the last column of the sheet.
As the same to the lines.
But the excel doesn't like it, I starts acting weird.
So, are there anything that I can do to prevent the user from viewing the columns and that I don't want to show?

Am I making myself clear?

Thank you in advance.

 

[VBE313]

You could set the Scroll Area.

Worksheet.ScrollArea property (Excel)

Office VBA reference topic

docs.microsoft.com

Single Click Sheet1 under Microsoft Excel Objects in Visual Basic Editor (Alt + F11). Once you single clicked the Sheet1 (Sheet1) press F4 to open the Properties, and the ScrollArea is the third from the bottom.

 

[tico_ocit]

Wow didn't know about that!
That is powerfull! That is exactly what I was looking for.
Thank you!

 

[VBE313]

You are welcome!

 

[tico_ocit]

You are welcome!

Btw I used backcolour to Column CA and to row 4000 one just one sheet, and the size of the file increased almost 1MB!! Is it possible?!