activex add page number

1 次查看（过去 30 天）
Romain
Romain 2014-10-9
回答： Shuba Nandini 2024-12-24
Hello,
Is there a way to add the page number in an excel document with activex ?
Thanks,
R

请先登录，再回答此问题。

回答（1 个）

Shuba Nandini
Shuba Nandini 2024-12-24
Hi,
It is my understanding that you would like to add page number to the Excel Sheet. You can use "PageSetup" object with "CenterFooter" property to set the page numbers for the each sheet using the following command:
activeWorksheet.PageSetup.CenterHeader = "Page &P of &N"
I hope this helps!

类别

在 Help Center 和 File Exchange 中查找有关 ActiveX 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by