为Excel工作表提供类似外观的表单，只启用固定数量的行和列

Is there a way to activate only a smaller section of excel sheet and deactivate rest of the sheet, meaning that only say a A4 size is visible and the rest part is grey and nothing happens when you click the grey part. (EG: Sheet consists of say only 20 rows and 7 colums).

有没有办法只激活excel工作表的较小部分并停用工作表的其余部分,这意味着只能说A4尺寸可见,其余部分是灰色的,单击灰色部分时没有任何反应。 (EG:Sheet仅包含20行和7列)。

I want to basically, make the sheet appear like a form, where the User can only edit or use certain parts and not the entire sheet.

我基本上想要使表单看起来像一个表单,用户只能编辑或使用某些部分而不是整个表单。

I have sheen before such type of sheets in presentation, but I don't know how it is done. Can anyone help me with this.?

在介绍这种类型的床单之前,我有光泽,但我不知道它是如何完成的。谁能帮我这个。?

2 个解决方案

#1

You can find an answer that doesn't use VBA at Microsoft's support pages: https://support.microsoft.com/en-us/kb/214081

您可以在Microsoft的支持页面找到不使用VBA的答案:https://support.microsoft.com/en-us/kb/214081

#2

Okay, so I finally managed giving the sheet a Formular look or in other words, make the appearance of the sheet like a form, without using the Protecting Sheet option.

好吧,所以我最终设法给表单一个Formular外观,换句话说,使表单的外观像一个表单,而不使用Protecting Sheet选项。

So say I want the sheet to have 20 rows and upto column G. Its just required to run the following 2-line macro:

所以说我希望工作表有20行,直到G列。它只需要运行以下2行宏:

            Sub Form_Look()
            Rows("21:1048576").RowHeight = 0 'Last Row of a Sheet is 1048576
            Columns("G:XFD").ColumnWidth = 0 'Last Column of a Sheet is XFD
            End Sub

And now just run the macro once. Hide it , delete it, whatever, But now the sheet will permanently on saving, look like you designed. :)

现在只需运行一次宏。隐藏它,删除它,无论如何,但现在该表将永久保存,看起来像你设计的。 :)

#1